Can somebody check over my SQL query here its only 1 line

[AnalGoat11]

When I run the following: get the erorr:

[SQL] alter table 'items_rooms' set 'user_id' = '374' where 'user_id' = '2'

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''items_rooms' set 'user_id' = '374' where 'user_id' = '2'' at line 1

alter table 'items_rooms' set 'user_id' = '374' where 'user_id' = '2'

 

[Sledmore]

UPDATE `items_rooms` SET `user_id` = '374' WHERE `user_id` = '2'

 

[AnalGoat11]

UPDATE `items_rooms` SET `user_id` = '374' WHERE `user_id` = '2'

Thanks so much, this worked!