当前位置：网站首页>sql 一般模糊查询语句,查询表T , 表T2的SEQ是条件，请问模糊查询如何能够匹配表T2的SEQ多个字符?

sql 一般模糊查询语句,查询表T , 表T2的SEQ是条件，请问模糊查询如何能够匹配表T2的SEQ多个字符?

2022-04-21 08:38:00 【CSDN问答】

执行脚本，没有结果

;with T as(select '09 22 25' notextunion all select '16 18 29' union all select '11 21 23' union all select '06 08 19' union all select '03 05 25' ),T2 as(select '25' SEQunion all select '29' union all select '19' ）select notext from T where notext LIKE '% + select CAST(SEQ AS INT) from T2 + %'

想得到的结果

notext
09 22 25
16 18 29
06 08 19
03 05 25

采纳答案：

没这么复杂，使用 EXISTS子查询即可
以下SQL在MySQL 8中运行通过

WITH t AS (        SELECT '09 22 25' notext UNION ALL        SELECT '16 18 29' notext UNION ALL        SELECT '11 21 23' notext UNION ALL        SELECT '06 08 19' notext UNION ALL        SELECT '03 05 25' notext UNION ALL        SELECT '15 29 19' notext ) -- 这条数据，INNER JOIN 会输出 2 条一样的重复数据    , t2 AS (        SELECT '25' seq UNION ALL        SELECT '29' seq UNION ALL        SELECT '19' seq )-- SELECT notext FROM t JOIN t2 ON t.notext LIKE concat( '%', t2.seq, '%' ); SELECT notext FROM t WHERE EXISTS( SELECT 1 FROM t2 WHERE t.notext LIKE concat( '%', t2.seq, '%' ) );