I have a populated MySQL TABLE where I need to pre-append the text "NEW_" for the name field. (Long story, but this is what needs to be done for now.)
I imagine this can be done with an UPDATE but I'm not sure how to add "NEW_" to the start of the 'name' column. I also work in PHP, so I need to do this in PHP where I read each record, extract 'name' field, add this and then do an UPDATE for the record? Or can this all be done in MySQL?
use this query
UPDATE table_name set `name` = CONCAT('NEW_',`name`)
name in your example? What is the difference between not using ` surrounding the field name? Thanks!
select group from tbl_tp It will generate error. But if you use select ` group` from tbl_tp, It will not generate error and query will be executed.You can use CONCAT like this:
UPDATE tbl SET name=CONCAT('NEW_',name)
WHERE name NOT LIKE 'NEW\_%';
The second line will stop this operating on columns with NEW_ already at the start.
NEW\_ to see it as a literal.You can just do it like this:
UPDATE myTable SET name = CONCAT('NEW_',name);
As posted before by myself this will not work:
UPDATE myTable SET name = 'NEW_' + name;
