|
Your description is kind of odd but I think you are looking for CONCAT.
SELECT CONCAT(`animal`,'zombie') AS animal FROM pets WHERE `item` = 'dog'
If you mean you want to replace dog, cat, and fish with 'zombie' then
REPLACE(`animal`,'dog','zombie')
If you want to replace multiple, then something like
REPLACE(REPLACE(REPLACE(`animal`,'fish','zombie'), 'cat','zombie'),'dog','zombie')
|