func_like.result

这是linux下运行的mysql软件包,可用于linux 下安装 php + mysql + apach 的网络配置

drop table if exists t1;
create table t1 (a varchar(10), key(a));
insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test");
explain select * from t1 where a like 'abc%';
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	index	a	a	13	NULL	5	Using where; Using index
explain select * from t1 where a like concat('abc','%');
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	index	a	a	13	NULL	5	Using where; Using index
select * from t1 where a like "abc%";
a
abc
abcd
select * from t1 where a like concat("abc","%");
a
abc
abcd
select * from t1 where a like "ABC%";
a
abc
abcd
select * from t1 where a like "test%";
a
test
select * from t1 where a like "te_t";
a
test
select * from t1 where a like "%a%";
a
a
abc
abcd
select * from t1 where a like "%abcd%";
a
abcd
select * from t1 where a like "%abc\d%";
a
abcd
drop table t1;
create table t1 (a varchar(10), key(a));
insert into t1 values ('a'), ('a\\b');
select * from t1 where a like 'a\\%' escape '#';
a
a\b
select * from t1 where a like 'a\\%' escape '#' and a like 'a\\\\b';
a
a\b
prepare stmt1 from 'select * from t1 where a like \'a\\%\' escape ?';
set @esc='#';
execute stmt1 using @esc;
a
a\b
deallocate prepare stmt1;
drop table t1;
create table t1 (a datetime);
insert into t1 values ('2004-03-11 12:00:21');
select * from t1 where a like '2004-03-11 12:00:21';
a
2004-03-11 12:00:21
drop table t1;
SET NAMES koi8r;
CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET koi8r);
INSERT INTO t1 VALUES ('瀑琢'),('尜琢'),('迄琢'),('瀑髁'),('瀑揍'),('纟麽');
INSERT INTO t1 VALUES ('瀑琢幸咸闹'),('尜琢幸咸闹'),('迄琢幸咸闹'),('瀑髁幸咸闹');
INSERT INTO t1 VALUES ('瀑揍幸咸闹'),('瀑琢鹨咸闹'),('瀑琢序咸闹'),('瀑琢幸锾闹');
INSERT INTO t1 VALUES ('瀑琢幸响闹'),('瀑琢幸咸渲'),('瀑琢幸咸啮'),('纟麽痱镬漩');
SELECT * FROM t1 WHERE a LIKE '%迄琢%';
a
瀑琢
尜琢
迄琢
瀑髁
瀑揍
纟麽
瀑琢幸咸闹
尜琢幸咸闹
迄琢幸咸闹
瀑髁幸咸闹
瀑揍幸咸闹
瀑琢鹨咸闹
瀑琢序咸闹
瀑琢幸锾闹
瀑琢幸响闹
瀑琢幸咸渲
瀑琢幸咸啮
纟麽痱镬漩
SELECT * FROM t1 WHERE a LIKE '%迄