create table t1(id int(4),des1 varchar(10));
insert into t1 values('1','广州');
insert into t1 values('2','中山');
insert into t1 values('3','武汉');create table t2(name varchar(10),des2 varchar(20));
insert into t2 values('aaa','广州;深圳;北京');
insert into t2 values('b','番禹;珠海');
insert into t2 values('ccc','武汉;珠海');
要求得到t1的id和对应的t2的des.
就是说如果t1的des包含在t2.des中。则把t2改行的name就提取出来。select t1.id,t2.name
from t1,t2
where t1.des1 REGEXP t2.des2结果返回了0行!!!!
insert into t1 values('1','广州');
insert into t1 values('2','中山');
insert into t1 values('3','武汉');create table t2(name varchar(10),des2 varchar(20));
insert into t2 values('aaa','广州;深圳;北京');
insert into t2 values('b','番禹;珠海');
insert into t2 values('ccc','武汉;珠海');
要求得到t1的id和对应的t2的des.
就是说如果t1的des包含在t2.des中。则把t2改行的name就提取出来。select t1.id,t2.name
from t1,t2
where t1.des1 REGEXP t2.des2结果返回了0行!!!!
from t1,t2
where instr(t2.des2,t1.des1)>0
mysql> select t2.name from t1,t2 where instr(t2.des2,t1.des1)>0;
+------+
| name |
+------+
| aaa |
| ccc |
+------+
2 rows in set (0.00 sec)mysql>
from t1,t2
where instr(t2.des2,t1.des1)>0