11/21/2005
MySQL String Functions
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: 14%
