zontrakulla Posted June 9, 2013 Share Posted June 9, 2013 -edit- 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 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. 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
Archived
This topic is now archived and is closed to further replies.