nigelt74 - 11:59 pm on Jun 10, 2010 (gmt 0)
Ok Problem solved, not elegantly but it worked
I ran a query to remove the first character '/' of all the strings
then ran my query slightly modified
UPDATE `zen_products` SET `products_image` = CONCAT('numerical/', `products_image`)
where `products_image` REGEXP '^[^[:alpha:]]'
The ran a query to add a prefix of '/' to all the fields