Bug #12785 Updated: Issuing a SELECT like '%xx' returns WRONG data!
| From: | gf at gfsoft dot se | Date: | Thu, 16 Aug 2001 10:17:19 +0000 |
| Subject: | Bug #12785 Updated: Issuing a SELECT like '%xx' returns WRONG data! | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-63403@lists.php.net to get a copy of this message | ||
ID: 12785
User updated by: gf@gfsoft.se
Reported By: gf@gfsoft.se
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] swm@php.net
This question is related to the MySQL database, not PHP. See
www.mysql.com for support.
------------------------------------------------------------------------
[2001-08-16 06:13:50] gf@gfsoft.se
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