mysql like时查询不到数据,实际是有的
sql如下:
CREATE TABLE test_char1(
`test_name` varchar(32) NOT NULL DEFAULT '' COMMENT '',
KEY `test_name` (`test_name`(3))
)ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
INSERT into test_char1 VALUES('蓝光C1'),('蓝光C2'),('蓝光C3'),('蓝'),('蓝光123');
SELECT * FROM test_char1 where test_name like '蓝光C%';
SELECT * FROM test_char1 where test_name like '蓝光%';
SELECT * FROM test_char1 where test_name like '蓝%';
上面加粗的sql查不到数据,求大神告知、、
谢谢!!!!