php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #12785 Issuing a SELECT like '%xx' returns WRONG data!
Submitted: 2001-08-16 06:13 UTC Modified: 2001-08-16 09:04 UTC
From: gf at gfsoft dot se Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.0.4 OS: RedHat 7.1
Private report: No CVE-ID: None
 [2001-08-16 06:13 UTC] gf at gfsoft dot 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' !!!

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-08-16 06:16 UTC] swm@php.net
This question is related to the MySQL database, not PHP. See
www.mysql.com for support.
 [2001-08-16 06:17 UTC] gf at gfsoft dot 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' !!!


The same thing happens while issuing 
SELECT * FROM CHEM where KEMIKALIE REGEXP "ol$" !!
 [2001-08-16 06:39 UTC] derick@php.net
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 09:03 UTC] gf at gfsoft dot se
No bug! That was my mistake.....-:)
 
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Sat May 28 05:09:35 2022 UTC