Search by one column to add text at the end of another

[mharrison]

I've found this link: http://stackoverflow.com/questions/1...-a-text-column

Which shows me how to add text to the end of a field when searching in that field. However, what I am wanting to do is search 1 field (which is a URL containing field) for a specific string of text, and if it exists, insert some text at the end of another field in the same row.

Field Names: dsptxt and lnktxt

If it finds www.exampleurl.com in lnktxt
then insert HI There at the end of the existing data in dsptxt.

Not sure if possible, but I imagine it is...just not able to figure out how to edit the queries listed in the example link I provided. Any help would be appreciated.

[Old Pedant]

UPDATE nameOfYourTable
SET dsptxt = CONCAT( dsptxt, ' HI There' )
WHERE lnktxt LIKE '%www.exampleurl.com%'

???

Is that all? Or do you mean something more specific?

[mharrison]

Originally Posted by Old Pedant

UPDATE nameOfYourTable
SET dsptxt = CONCAT( dsptxt, ' HI There' )
WHERE lnktxt LIKE '%www.exampleurl.com%'

???

Is that all? Or do you mean something more specific?

That was it exactly! Thank you very much for the help!