blob: e0f1f0db9cef0bb69cd7505b9d8f50954568e32e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
#
# Test of like
#
drop table if exists t1;
create table t1 (a varchar(10), key(a));
insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test");
select * from t1 where a like "abc%";
select * from t1 where a like "ABC%";
select * from t1 where a like "test%";
select * from t1 where a like "te_t";
drop table t1;
|
