Help with SQL Query

[Nitrofish]

I want to update the image columns of a range of id's so that each song on an album references only one file 'image_name.jpg' instead of the same file with different file names. This doesn't work. Is this possible, or am I just doing it wrong?

UPDATE `database_name`.`songs` SET `image`='image_name.jpg' WHERE `ID`=10, 11, 12, 13, 14, 15, 16, 17;

[stevewa]

UPDATE `database_name`.`songs`
SET `image`='image_name.jpg'
WHERE `ID`IN (10, 11, 12, 13, 14, 15, 16, 17)
;

[Nitrofish]

Have your tested this? I'll give it a try and report back. Thank you.

UPDATE: Works fine, thanks so much! This will save me so much time!

[stevewa]

welcome!