mysql 4, pretty standard table. This query works fine using
the command line mysql client:
DELETE FROM raw_pings WHERE hostname LIKE 'www.faz.de';
but if I try it via PMA, it asks
Voulez-vous vraiment effectuer :
DELETE FROM raw_pings WHERE hostname LIKE 'www.faz.de' ?
which is perfectely correct, but after if fails displaying:
requęte SQL :
DELETE FROM raw_pings WHERE hostname LIKE \ 'www.faz.de\'
MySQL a répondu:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '\ 'www.faz.de\'' at line 1
It seems there is a problem somewhere... theses quotes _shouldn't_ be backslashed, and it adds a space at the wrong place (after LIKE, before the quote symbol). simple regexp problem? (magic_quotes_gpc=On, magic_quotes_runtime=Off )