I want to update the code on all my record to what they currently are plus _standard any ideas?
So for example if the codes are apple_1 and apple_2 I need them to be apple_1_standard and apple_2_standard
id code
------------
1 apple_1
1 apple_2
update categories set code = code + "_standard" where id = 1;
id code
----------------------
1 apple_1_standard
1 apple_2_standard
Update image field to add full URL, ignoring null fields:
UPDATE test SET image = CONCAT('https://my-site.com/images/',image) WHERE image IS NOT NULL;
Source: Stackoverflow.com