CODEWITHSUNDEEP
mysqldatabasesql-update
aled2305
aled2305

Reputation: 132

Update section of column in mySQL

I have a mySQL database containing information on pictures.

Now I would like to edit the title of the images, but using zenPhoto this would take days. So I was hoping that there is a way of mas updating using mySQL.

I want to replace the text in the title column from rows 105 to row 378 with 'New York 2007'

I have see something like UPDATE zp_images SET title = New York 2007 to update the entire column, but don't know about the rows.

Thanks in advance

Aled

Upvotes: 1

Views: 52

Answers (1)

Suhel Meman
Suhel Meman

Reputation: 3852

Hope this helps u... 

update table_name set title ='New York 2007' where id >= 120 and id <= 460;

Upvotes: 1

Related Questions