I'm trying to take 3 MySQL values, and join them together into 1 string.
I could do this in PHP, but thought I may as well take advantage of the MySQL CONCAT() function. PHP's got enough to do without doing this through 20,000 records at a time
So here's a part of my query:
Code: Select all
SELECT CONCAT(`invoice_prefix`, `invoice_id`, `invoice_suffix`) AS `invoice_no`Is there any way in MySQL to achieve this?
Thanks, B