I want update all lex_desc with specific lang_code with all lex_desc with specific lang_code
how can i do this with sql in mySql ?
Maybe I misunderstand you question, but...
UPDATE yourtable SET lex_desc = 'some test' WHERE lang_code = 'EN'
To make it more versatile, but still fairly simple, try:
UPDATE yourtable SET lex_desc = CASE
WHEN lang_code = 'EN' THEN 'English'
WHEN 'KR' THEN 'Korean'
17 People are following this question.