Description:
like not correct working :((
see How to repeat:
How to repeat:
DROP TABLE IF EXISTS `testlike`;
Query OK, 0 rows affected, 1 warning (0,00 sec)
mysql> CREATE TABLE `testlike` (
-> `id` int(3) unsigned NOT NULL auto_increment,
-> `name` varchar(100) default NULL,
-> PRIMARY KEY (`id`)
-> ) TYPE=MyISAM DEFAULT CHARSET=cp1251;
Query OK, 0 rows affected (0,05 sec)
mysql> INSERT INTO `testlike` (`id`, `name`) VALUES("1", "mysql / forever"); Query OK, 1 row affected (0,00 sec)
mysql> select * from testlike where name like "%for%";
+----+-----------------+
| id | name |
+----+-----------------+
| 1 | mysql / forever |
+----+-----------------+
1 row in set (0,00 sec)
mysql> select * from testlike where name like "%fore%";
+----+-----------------+
| id | name |
+----+-----------------+
| 1 | mysql / forever |
+----+-----------------+
1 row in set (0,00 sec)
mysql> select * from testlike where name like "%forev%";
Empty set (0,00 sec)
mysql> select * from testlike where name like "%foreve%";
Empty set (0,00 sec)
mysql> select * from testlike where name like "%forever%";
Empty set (0,00 sec)
mysql> select * from testlike where name like "% forever%";
+----+-----------------+
| id | name |
+----+-----------------+
| 1 | mysql / forever |
+----+-----------------+
1 row in set (0,00 sec)
show variables;
...
version | 4.1.1-alpha-standard-log
...
character_set_server | cp1251 |
| character_set_system | utf8 |
| character_set_database | cp1251 |
| character_set_client | cp1251 |
| character_set_connection | cp1251 |
| character-sets-dir | /usr/share/mysql/charsets/ |
| character_set_results | cp1251 |
| collation_connection | cp1251_general_ci |
| collation_database | cp1251_general_ci |
| collation_server | cp1251_general_ci
Suggested fix:
:(