ID: 12785 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: MySQL related Operating System: RedHat 7.1 PHP Version: 4.0.4 New Comment: No bug! That was my mistake.....-:) Previous Comments: ------------------------------------------------------------------------ [2001-08-16 06:39:20] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ [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]