mysql 模糊匹配语法 假如有如下两张表:A ID NAME AGE 1 aaa 10 2 BdB 10 3 CbC 10B ID key 1 a 2 d 如何一条语句查询出A表中 包含B表的key字段值的的记录 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 要求结果 是什么,哪个字段包含B表的key字段 是这个意思?mysql> select * from ta;+------+------+------+| id | name | age |+------+------+------+| 1 | aaa | 10 || 2 | BdB | 10 || 3 | CbC | 10 || 4 | ddd | 10 |+------+------+------+4 rows in set (0.00 sec)mysql> select * from tb;+------+------+| id | key |+------+------+| 1 | a || 2 | b |+------+------+2 rows in set (0.00 sec)mysql> select * from ta, tb where name rlike `key`;+------+------+------+------+------+| id | name | age | id | key |+------+------+------+------+------+| 1 | aaa | 10 | 1 | a || 2 | BdB | 10 | 2 | b || 3 | CbC | 10 | 2 | b |+------+------+------+------+------+3 rows in set (0.00 sec) select *from a,bwhere instr(A.name,B.key)>0 select * from a inner join b on instr(A.`name`,B.`key`)>0 请教一个SQL查询语句 为什么下面这个存储过程在mysql中运行后,会出现如下错误提示?怎样解决? 如何删除db中除了pk其他都一样的记录呢? 【【【高分求救】】关于mysql 全文索引出错 这个sql语句啥意思? MySql的存储过程怎么来写 mysql批处理问题.求教,急!!!! 江湖告急!!!!!!!!!! mysql导出的上百兆sql格式数据怎样导入ms sql? 求助mysql高手,如何查询这样的关联记录? 用mysql在Spring Security中配置的问题,求牛人帮忙解答!!! 关于mysql-cluster用于实际生产环境的问题
+------+------+------+
| id | name | age |
+------+------+------+
| 1 | aaa | 10 |
| 2 | BdB | 10 |
| 3 | CbC | 10 |
| 4 | ddd | 10 |
+------+------+------+
4 rows in set (0.00 sec)mysql> select * from tb;
+------+------+
| id | key |
+------+------+
| 1 | a |
| 2 | b |
+------+------+
2 rows in set (0.00 sec)mysql> select * from ta, tb where name rlike `key`;
+------+------+------+------+------+
| id | name | age | id | key |
+------+------+------+------+------+
| 1 | aaa | 10 | 1 | a |
| 2 | BdB | 10 | 2 | b |
| 3 | CbC | 10 | 2 | b |
+------+------+------+------+------+
3 rows in set (0.00 sec)
from a,b
where instr(A.name,B.key)>0