change part of a field

[shawjames]

Hello,
Can anyone help me with this one? I would like to change part of a field.

So the "where" will be:

UPDATE db_items SET pName="XYZ****" WHERE pName like "ABC%"

So a field like "ABC123" would change to "XYZ123"

Any ideas?
Thanks!
-Shaw

[tomhath]

Maybe either REPLACE, or SUBSTRING and CONCAT. Read up on the various string functions:

http://dev.mysql.com/doc/mysql/en/string-functions.html