mysql基础 Like关联查询
时间：2021-07-01 10:21:17
帮助过：14人阅读
mysql中使用concat连接字符串
select t1.id, t1.title, t2.keyword
from t1
inner join t2
on t1.title
like concat(
‘%‘, t2.keyword,
‘%‘);
其它思路：exists(是否存在)、regexp(正则)、instr(字符串包含)
select distinct t1.title
from t1 , t2
where instr(t1.title,t2.keyword);
select distinct t1.title
from t1
inner join t2
on t1.title regexp t2.keyword;
select * from t1
where exists (
select keyword
from t2
where t1.title regexp keyword);
select * from t1
where exists (
select keyword
from t2
where t1.title
like concat(
‘%‘,keyword,
‘%‘));
https://blog.csdn.net/bbirdsky/article/details/26054971
mysql基础 Like关联查询
标签：word detail color rds 字符串包含 article net 存在 http
