[RESOLVED] update data

[auddog]

I have an address field in one of my databases and I would like to append some more information to the field. Currently I have OH Cleveland in the field but I want to add the word Discount to the end so it would look something like OH Cleveland Discount. I currently have about 500 addresses to change and have no idea how to change them other than individually. Any help would be greatly appreciated.

A

[cgraz]

What is it that you're aiming to do by adding the word "Discount" to the address field? Why do you have City and State in an address field? Right off the bat, this doesn't seem like an efficient way to do this...

Nevertheless, what is your criteria for adding the word "Discount" to the end of the field? If you want to add the word Discount to all address fields that have "OH Cleveland" as values:

update <your_table>
 set address = concat(address, ' ', 'Discount') 
where address = 'OH Cleveland'

If you want to add it to all fields, drop the where clause.

[auddog]

Thank you very much, that worked like a charm.