One quick question, I am trying just replace part of the entry ie:
change:
/image/covers/009.jpg
to
image/covers/09.jpg
I have tried to update products set products_image='image/covers' where
products_image like '/images/covers%'; but it seems to replace the whole
field and not leave the trailing data. Ie it changes /image/covers/09.jpg to
image/covers. Any ideas. Thanks in advance.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
