SQL中用一个关键字(词)匹配表里面多个字段(或属性)进行查询

1、常见的SQL查询

--  常见SQL查询
select id,name,type,tag,status,'A' tablename from TABLEONE

-- 或者
SELECT * FROM TABLEONE;(SELECT A.* FROM TABLEONE A);


--  常见条件查询
select id,name,type,tag,status,'A' tablename from TABLEONE where id=1;

-- 或者
SELECT * FROM TABLEONE WHERE name = '名称';

SELECT A.* FROM TABLETWO A WHERE A.NAME LIKE '%名字%';

-- 亦或者多个条件查询
SELECT * FROM TABLEONE WHERE name = 'test' and id=1;

SELECT A.* FROM TABLETWO A WHERE A.NAME LIKE '%名字%';

-- 嵌套
SELECT * FROM TABLEONE WHERE name = 'test' and id in ('1','2','3','');

SELECT A.* FROM TABLETWO WHERE ID IN (

        select id from TABLEONE WHERE name LIKE '%名字%'

    );

2、多字段查询

-- 单表单条件多字段查询
select id,name,type,tag,status,'B' tablename from TABLETWO WHERE CONCAT(id,name) LIKE '%123456%';

-- 多表单条件多字段查询
SELECT * FROM(
            select id,name,type,tag,status,'A' tablename from TABLEONE
            UNION
            select id,name,type,tag,status,'B' tablename from TABLETWO) AB 
        WHERE CONCAT(id,name,type,tag) LIKE "%123456%";

以上为SQL的具体实现。

以下为代码的具体实现。

SpringBoot中SQL多字段查询的具体写法https://blog.csdn.net/qq_43544074/article/details/120483861