CartMetrix - Do you know yours?

« Mighty Mouse Trackball Woes | Home | MySQL String Function Concat »

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%

Trackback:

Related Posts

Post your opinion

Verification Image

Please type the letters you see in the picture.

Subscribe without commenting


damonparker.org is proudly powered by WordPress
Entries (RSS) and Comments (RSS).

copyright © 2002-2008 damonparker.org. all rights reserved.

Close
E-mail It