F Scott Fitzgerald Total Post:28 Points:196 Posted by F Scott Fitzgerald July-09-2013 3:19 AM MYSQL MYSQL 1 Reply(s) 1840 View(s) Ratings: Rate this: Hi Expert! I'm trying to replace a column value based off values from other columns, but I keep getting syntax errors. What am I doing wrong? Here's what I've tired: SELECT * FROM `table` WHERE `id_1` =164 and `id_2` = 6 SET `id_1` = (188|164) WHERE `id_1` = 164 AND `id_2` = 6 UPDATE `table` This gives me a syntax near SET. SELECT * FROM `table` WHERE `id_1` = 164 AND `id_2` = 6 UPDATE `table` SET `id_1` = 188 WHERE `id_2` = 6 This gives me an error for everything below UPDATE. Help? Thanks.