php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 06 06:01:29 2025 UTC