MySql Search and Destroy

[Brendan_Nolan]

Hi,

I made a mistake when creating a PHP script, while creating rows in a table the PHP script said that if the person entering the data did not give a painting a title, then it would be saved to the database as Untitled. But I made a nasty typo and spelt it Untilted. So now we have stacks of paintings named Untilted.

I can see how I could make a PHP script to loop through untill it has changed all of those records, but is there some kind of pure SQL query that will do this change for me?

[hkucsis]

Update table_name set name="Untilted" where name = "Untilted"

Hope it helps.

[Brendan_Nolan]

Exactly what I needed, thanks!