ID: 12785 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Old Status: Closed Status: Open Bug Type: MySQL related Operating System: RedHat 7.1 PHP Version: 4.0.4 New Comment: 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$" !! Previous Comments: ------------------------------------------------------------------------ [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]