nigelt74 - 12:54 am on Jun 9, 2010 (gmt 0)
Ok the situation is this, i have a number of records stored in a database, like this
I need to add a prefix to those images that start with a number, but I can't figure out how to do it,
I wrote the following script
UPDATE `zen_products` SET `products_image` = CONCAT('/numerical', `products_image`)
where `products_image` REGEXP '^[^[:alpha:]]'
But unfortunately I had forgotten about the forward slash that prefixes the fields, and I cannot work out how to add that in to my regex, as I keep breaking it
Any help would be greatly appreciated