Update MySQL query throwing syntax error

Question

Trying to update a mysql employee table where the Group column if it contains the word staff it changes the contents of the column to a 4. What am I doing wrong?

UPDATE employee SET Group = "4" WHERE Group LIKE "Staff";

eggyal · Accepted Answer · 2012-06-05 15:08:52Z

3

GROUP is a reserved word. Quote it with backticks:

UPDATE employee SET `Group` = "4" WHERE `Group` LIKE "Staff";

answered Jun 5, 2012 at 15:08

eggyal

127k18 gold badges221 silver badges245 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andy · Accepted Answer · 2012-06-05 15:08:52Z

1

You need to quote the reserved word GROUP

if it contains the word staff

and wildcard operators % around LIKE to match any instance, not just the whole string (LIKE without wildcards is equivalent to =).

UPDATE employee SET `Group` = "4" WHERE `Group` LIKE "%Staff%";

answered Jun 5, 2012 at 15:08

Andy

17.8k9 gold badges55 silver badges70 bronze badges

Collectives™ on Stack Overflow

Update MySQL query throwing syntax error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related