MySQL String Functions allow for easy in situ data manipulation.
For example:
update products set products_image = replace(products_image, ‘products/’, ”);
Will update all products_image fields from:
products/product_image
to:
product_image
Stop writing PHP code to loop through the whole dataset to make changes.
Popularity: 1%
{ 0 comments }
