SET NAMES latin2; CREATE TABLE `m2` ( `metadata_id` int(11) NOT NULL default '0', `document_version_id` int(11) NOT NULL default '0', `document_type_metadata_id` int(11) NOT NULL default '0', `value` text NOT NULL, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` varchar(25) NOT NULL default '', `modified_on` datetime default NULL, `modified_by` varchar(25) default NULL, KEY `type_value_index` (`document_type_metadata_id`,`value`(10)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `m2` VALUES (40988,7850,72,'VOLNÝ ADSL','2006-02-17 16:16:45','dms2',NULL,NULL),(41009,7851,72,'VOLNÝ ADSL','2006-02-17 16:16:56','dms2',NULL,NULL),(41032,7852,72,'VOLNÝ ADSL','2006-02-17 16:16:58','dms2',NULL,NULL),(41038,7853,72,'VOLNÝ ADSL','2006-02-17 16:16:59','dms2',NULL,NULL),(41063,7854,72,'VOLNÝ ADSL','2006-02-17 16:17:05','dms2',NULL,NULL),(41084,7855,72,'VOLNÝ ADSL','2006-02-17 16:17:08','dms2',NULL,NULL),(41103,7856,72,'VOLNÝ ADSL','2006-02-17 16:17:11','dms2',NULL,NULL),(41537,7879,72,'VOLNÝ ADSL Office','2006-02-17 16:19:54','dms2',NULL,NULL),(42141,7911,72,'VOLNÝ ADSL','2006-02-17 16:26:20','dms2',NULL,NULL),(42164,7912,72,'VOLNÝ ADSL','2006-02-17 16:26:24','dms2',NULL,NULL),(42187,7913,72,'VOLNÝ ADSL','2006-02-17 16:26:39','dms2',NULL,NULL),(42210,7914,72,'VOLNÝ ADSL','2006-02-17 16:26:48','dms2',NULL,NULL),(42233,7915,72,'VOLNÝ ADSL','2006-02-17 16:27:07','dms2',NULL,NULL),(42565,7933,72,'VOLNÝ ADSL Combi','2006-02-17 16:30:05','dms2',NULL,NULL),(42749,7941,72,'VOLNÝ ADSL','2006-02-17 16:30:26','dms2',NULL,NULL),(42862,7946,72,'VOLNÝ ADSL','2006-02-17 16:30:37','dms2',NULL,NULL),(42868,7947,72,'VOLNÝ ADSL','2006-02-17 16:30:37','dms2',NULL,NULL),(42893,7948,72,'VOLNÝ ADSL','2006-02-17 16:30:41','dms2',NULL,NULL),(42916,7949,72,'VOLNÝ ADSL','2006-02-17 16:30:45','dms2',NULL,NULL),(42939,7950,72,'VOLNÝ ADSL','2006-02-17 16:30:47','dms2',NULL,NULL),(42962,7951,72,'VOLNÝ ADSL','2006-02-17 16:30:49','dms2',NULL,NULL),(42985,7952,72,'VOLNÝ ADSL','2006-02-17 16:30:51','dms2',NULL,NULL),(43402,7972,72,'VOLNÝ ADSL','2006-02-17 16:33:46','dms2',NULL,NULL),(43408,7973,72,'VOLNÝ ADSL','2006-02-17 16:33:46','dms2',NULL,NULL),(44092,8010,72,'VOLNÝ ADSL','2006-02-17 16:36:05','dms2',NULL,NULL),(44115,8011,72,'VOLNÝ ADSL','2006-02-17 16:36:09','dms2',NULL,NULL),(44138,8012,72,'VOLNÝ ADSL','2006-02-17 16:36:13','dms2',NULL,NULL),(44182,8014,72,'VOLNÝ ADSL','2006-02-17 16:36:17','dms2',NULL,NULL),(44205,8015,72,'VOLNÝ ADSL','2006-02-17 16:36:22','dms2',NULL,NULL); ql> select * from m2 where document_type_metadata_id=72 and value LIKE 'VOLNY ADSL'; +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ | metadata_id | document_version_id | document_type_metadata_id | value | created_on | created_by | modified_on | modified_by | +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ | 40988 | 7850 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:45 | dms2 | NULL | NULL | | 41009 | 7851 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:56 | dms2 | NULL | NULL | | 41032 | 7852 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:58 | dms2 | NULL | NULL | | 41038 | 7853 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:59 | dms2 | NULL | NULL | | 41063 | 7854 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:05 | dms2 | NULL | NULL | | 41084 | 7855 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:08 | dms2 | NULL | NULL | | 41103 | 7856 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:11 | dms2 | NULL | NULL | | 42141 | 7911 | 72 | VOLNÝ ADSL | 2006-02-17 16:26:20 | dms2 | NULL | NULL | | 42164 | 7912 | 72 | VOLNÝ ADSL | 2006-02-17 16:26:24 | dms2 | NULL | NULL | | 42187 | 7913 | 72 | VOLNÝ ADSL | 2006-02-17 16:26:39 | dms2 | NULL | NULL | | 42210 | 7914 | 72 | VOLNÝ ADSL | 2006-02-17 16:26:48 | dms2 | NULL | NULL | | 42233 | 7915 | 72 | VOLNÝ ADSL | 2006-02-17 16:27:07 | dms2 | NULL | NULL | | 42749 | 7941 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:26 | dms2 | NULL | NULL | | 42862 | 7946 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:37 | dms2 | NULL | NULL | | 42868 | 7947 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:37 | dms2 | NULL | NULL | | 42893 | 7948 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:41 | dms2 | NULL | NULL | | 42916 | 7949 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:45 | dms2 | NULL | NULL | | 42939 | 7950 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:47 | dms2 | NULL | NULL | | 42962 | 7951 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:49 | dms2 | NULL | NULL | | 42985 | 7952 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:51 | dms2 | NULL | NULL | | 43402 | 7972 | 72 | VOLNÝ ADSL | 2006-02-17 16:33:46 | dms2 | NULL | NULL | | 43408 | 7973 | 72 | VOLNÝ ADSL | 2006-02-17 16:33:46 | dms2 | NULL | NULL | | 44092 | 8010 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:05 | dms2 | NULL | NULL | | 44115 | 8011 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:09 | dms2 | NULL | NULL | | 44138 | 8012 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:13 | dms2 | NULL | NULL | | 44182 | 8014 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:17 | dms2 | NULL | NULL | | 44205 | 8015 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:22 | dms2 | NULL | NULL | +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ 27 rows in set (0.00 sec) // This is correct mysql> select * from m2 where document_type_metadata_id=72 and value LIKE 'VOLNÝ ADSL'; Empty set (0.00 sec) // This is incorrect, should be same result set as above. ql> select * from m2 where document_type_metadata_id=72 and value LIKE '%VOLNÝ ADSL'; +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ | metadata_id | document_version_id | document_type_metadata_id | value | created_on | created_by | modified_on | modified_by | +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ | 40988 | 7850 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:45 | dms2 | NULL | NULL | | 41009 | 7851 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:56 | dms2 | NULL | NULL | | 41032 | 7852 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:58 | dms2 | NULL | NULL | | 41038 | 7853 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:59 | dms2 | NULL | NULL | | 41063 | 7854 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:05 | dms2 | NULL | NULL | | 41084 | 7855 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:08 | dms2 | NULL | NULL | | 41103 | 7856 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:11 | dms2 | NULL | NULL | | 42141 | 7911 | 72 | VOLNÝ ADSL | 2006-02-17 16:26:20 | dms2 | NULL | NULL | | 42164 | 7912 | 72 | VOLNÝ ADSL | 2006-02-17 16:26:24 | dms2 | NULL | NULL | | 42187 | 7913 | 72 | VOLNÝ ADSL | 2006-02-17 16:26:39 | dms2 | NULL | NULL | | 42210 | 7914 | 72 | VOLNÝ ADSL | 2006-02-17 16:26:48 | dms2 | NULL | NULL | | 42233 | 7915 | 72 | VOLNÝ ADSL | 2006-02-17 16:27:07 | dms2 | NULL | NULL | | 42749 | 7941 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:26 | dms2 | NULL | NULL | | 42862 | 7946 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:37 | dms2 | NULL | NULL | | 42868 | 7947 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:37 | dms2 | NULL | NULL | | 42893 | 7948 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:41 | dms2 | NULL | NULL | | 42916 | 7949 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:45 | dms2 | NULL | NULL | | 42939 | 7950 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:47 | dms2 | NULL | NULL | | 42962 | 7951 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:49 | dms2 | NULL | NULL | | 42985 | 7952 | 72 | VOLNÝ ADSL | 2006-02-17 16:30:51 | dms2 | NULL | NULL | | 43402 | 7972 | 72 | VOLNÝ ADSL | 2006-02-17 16:33:46 | dms2 | NULL | NULL | | 43408 | 7973 | 72 | VOLNÝ ADSL | 2006-02-17 16:33:46 | dms2 | NULL | NULL | | 44092 | 8010 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:05 | dms2 | NULL | NULL | | 44115 | 8011 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:09 | dms2 | NULL | NULL | | 44138 | 8012 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:13 | dms2 | NULL | NULL | | 44182 | 8014 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:17 | dms2 | NULL | NULL | | 44205 | 8015 | 72 | VOLNÝ ADSL | 2006-02-17 16:36:22 | dms2 | NULL | NULL | +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ 27 rows in set (0.00 sec) // This is very interesting, left % fixed it ALTER TABLE m2 DROP KEY type_value_index; ALTER TABLE m2 ADD KEY type_value_index (`document_type_metadata_id`,`value`(11)); select * from m2 where document_type_metadata_id=72 and value LIKE 'VOLNÝ ADSL'; +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ | metadata_id | document_version_id | document_type_metadata_id | value | created_on | created_by | modified_on | modified_by | +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ | 40988 | 7850 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:45 | dms2 | NULL | NULL | | 41009 | 7851 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:56 | dms2 | NULL | NULL | | 41032 | 7852 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:58 | dms2 | NULL | NULL | | 41038 | 7853 | 72 | VOLNÝ ADSL | 2006-02-17 16:16:59 | dms2 | NULL | NULL | | 41063 | 7854 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:05 | dms2 | NULL | NULL | | 41084 | 7855 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:08 | dms2 | NULL | NULL | | 41103 | 7856 | 72 | VOLNÝ ADSL | 2006-02-17 16:17:11 | dms2 | NULL | NULL | +-------------+---------------------+---------------------------+------------+---------------------+------------+-------------+-------------+ 7 rows in set (0.00 sec) // This is interesting, only first 7 rows before first long entry ("VOLNÝ ADSL Office") returned