database - Update section of column in mySQL -


i have mysql database containing information on pictures.

now edit title of images, using zenphoto take days. hoping there way of mas updating using mysql.

i want replace text in title column rows 105 row 378 'new york 2007'

i have see update zp_images set title = new york 2007 update entire column, don't know rows.

thanks in advance

aled

hope helps u...

update table_name set title ='new york 2007' id >= 120 , id <= 460; 

Comments