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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: gf at gfsoft dot se
New email:
PHP Version: OS:

 

 [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: Mon May 16 16:05:46 2022 UTC