Hi!
We just encountered that MySQL seeems not to accept a "LIKE '%...'" clause
in a DELETE statement. In the annotated online documentation it is said a
DELETE statement can be followed by any valid WHERE clause. LIKE is listed
as a common string comparison function in the SELECT and WHERE functions
chapter.
So does MySQL actually deny LIKE in DELETEs as it seems to do or is there a
way to use this combination as you can guess reading the manual?!
Thanks in advance for a short "No, not possible" or a hint how it could
work.
Regards,
Sascha Dahl
_______________________________________________________________
b e s t E s h o p . d e A G · Sascha Dahl · IT Consultant
TZ/Friedrich-Ebert-Str. · 51429 Bergisch Gladbach · Germany
Phone: +49 (0)2204 - 84 34 03 · Fax: +49 (0)2204 - 84 34 19
mailto:[EMAIL PROTECTED] · http://www.besteforschung.de
---------------------------------------------------------------------
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