SQL Help

[MxSoft]

Hi, sorry for always ask about sql help but im just learning it.
This is a basic code i made that dont works, it is suppose to change the flag in accounts to Mexico where flag is mx.

UPDATE accounts SET flag = Mexico WHERE flag = mx

But it gaves me this error:

#1054 - Unknown column 'mx' in 'where clause'

What is wrong?

 

[Chris]

UPDATE `accounts` SET `flag` = 'Mexico' WHERE `flag` = 'mx';

 

[MxSoft]

UPDATE `accounts` SET `flag` = 'Mexico' WHERE `flag` = 'mx';

Ty Chris, so the code didnt worked because the ''?

 

[Chris]

Yeah, otherwise the engine thinks your text is a keyword. If no matching keyword is found, it will consider it a column instead.