Changing muliple entries in one go

[ld0121]

Hi all, I have a table with many columns, one of the columns is "ident" this is where I split the information in my database in to different categories. I want to change the ident words to numbers, but this needs to happen accross lots of rows.

ie. I want to change "ident" which = shop to 133

Is there an easy way to tell the database to change evey instance of the word shop in the ident column to 133, instead of me manually having to change each row one by one.

Any help would be great.

Thanks
Lee

[Installer]

Try UPDATE.

[TheDefender]

Or more specifically...

UPDATE your_table SET ident = 133 WHERE ident = 'shop'

[ld0121]

Thanks guys, thats saved me many hours of work. 🙂