zontrakulla Posted June 9, 2013 Share Posted June 9, 2013 (edited) -edit- Edited June 9, 2013 by zontrakulla Quote Link to comment https://forums.phpfreaks.com/topic/278946-what-is-wrong-with-this-mysql-query/ Share on other sites More sharing options...
Barand Posted June 9, 2013 Share Posted June 9, 2013 (edited) If group and m are column names, use backticks ` and not single quotes UPDATE users SET `group` = 9 WHERE `m` < 5 AND `group` = 8 Don't quote numbers, only string values. group is a reserved word and should be avoided as a column name. Edited June 9, 2013 by Barand Quote Link to comment https://forums.phpfreaks.com/topic/278946-what-is-wrong-with-this-mysql-query/#findComment-1434922 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.