| Bug #39632 | return all records when runing with like '%_%' statement | ||
|---|---|---|---|
| Submitted: | 24 Sep 2008 17:59 | Modified: | 24 Sep 2008 20:05 |
| Reporter: | dharmesh patel | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: FULLTEXT search | Severity: | S3 (Non-critical) |
| Version: | Server version: 5.0.45-log Source distri | OS: | Linux (2.6.18-92.1.6.el5.centos.plus) |
| Assigned to: | CPU Architecture: | Any | |
[24 Sep 2008 20:05]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Please read at http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like about LIKE syntax.
Description: hi There- I'm not sure this is already submitted or not. When running query with like '%_%' or like '_%' or like '%_' on any column it returns all records from table. Thansks, How to repeat: mysql> create table dp_test( -> name varchar(50) not null); Query OK, 0 rows affected (0.02 sec) mysql> mysql> insert into dp_test -> values('first_name_last_name'), -> ('firstname lastname'), -> ('first_name last_name'), -> ('fristnamelastname'); Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> mysql> select * -> from dp_test -> where name like '%_'; +----------------------+ | name | +----------------------+ | first_name_last_name | | firstname lastname | | first_name last_name | | fristnamelastname | +----------------------+ 4 rows in set (0.00 sec) should return only 2 rows. mysql> select * -> from db_counts.dp_test -> where name like '_%'; +----------------------+ | name | +----------------------+ | first_name_last_name | | firstname lastname | | first_name last_name | | fristnamelastname | +----------------------+ 4 rows in set (0.00 sec) should return only 2 rows. mysql> mysql> mysql> select * -> from db_counts.dp_test -> where name like '%_%'; +----------------------+ | name | +----------------------+ | first_name_last_name | | firstname lastname | | first_name last_name | | fristnamelastname | +----------------------+ 4 rows in set (0.00 sec)