Adding Prefix and Suffix to existing string values?

Databases
1

My sql is rusty and I need some help with this…

Basically, I need to add a prefix and a suffix to the contents of a cell for all records.

Example…

Single Column Table with 3 records…

UserNames
John
Emily
Fahd

I need to add the prefix “Prefix” and suffix “Suffix” to all records, so that it looks like this after sql query runs…

UserNames
PrefixJohnSuffix
PrefixEmilySuffix
PrefixFahdSuffix

I’ve been pouring through mysql syntax and documentation for a while but like I said my sql is a bit rusty and would appreciate any help!

Thanks! :slight_smile:

2

you want concat:

concat('Prefix', theColumn, 'Suffix')

usable in both selects and updates:

select concat('Prefix', theColumn, 'Suffix')
  from theTable;

update theTable
   set theColumn = concat('Prefix', theColumn, 'Suffix');
3

Thank you, much appreciated! :slight_smile:

4