ID: 12785
Updated by: derick
Reported By: [EMAIL PROTECTED]
Old Status: Open
Status: Bogus
Bug Type: MySQL related
Operating System: RedHat 7.1
PHP Version: 4.0.4
New Comment:

Select statements are not executed by PHP, but on the server. This is not a PHP bug.
Try executing the query with the commandline client to check the results.

Previous Comments:
------------------------------------------------------------------------

[2001-08-16 06:17:18] [EMAIL PROTECTED]

SELECT * FROM CHEM where KEMIKALIE like '%ol' does NOT report only the
KEMIKALIE ending with 'ol' BUT even those that include 'ol' that is: that
do not end with 'ol' !!!


The same thing happens while issuing 
SELECT * FROM CHEM where KEMIKALIE REGEXP "ol$" !!

------------------------------------------------------------------------

[2001-08-16 06:16:18] [EMAIL PROTECTED]

This question is related to the MySQL database, not PHP. See
www.mysql.com for support.

------------------------------------------------------------------------

[2001-08-16 06:13:50] [EMAIL PROTECTED]

SELECT * FROM CHEM where KEMIKALIE like '%ol' does NOT report only the KEMIKALIE 
ending with 'ol' BUT even those that include 'ol' that is: that do not end with 'ol' 
!!!

------------------------------------------------------------------------



Edit this bug report at http://bugs.php.net/?id=12785&edit=1


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to