I’ve successfully combined data from two columns using this script:
mysql_query("UPDATE catkey SET category_subcategory = CONCAT(category,subcategory)") or die(mysql_error());
I’d like to put 4 blank spaces between the data in category and the data from subcategory when CONCAT fills the category_subcategory column. I’ve tried several variations of the above script without success.
How to I need to change my script to add 4 blank spaces between the data?