2024-04-29 09:13:59
建表及数据
create table testa (ida int,name varchar(10),testa varchar(10))
insert into testa values (1,'大黄','清热解毒')
insert into testa values (2,'螳螂','清热解毒')
create table testb (idb int,testb varchar(10))
insert into testb values (1,'清热')
执行
select a.ida,b.idb from testa a,testb b where charindex(b.testb,a.testa)>0
结果
以上sqlserver可用,其他数据库另说,你用的什么数据库啊
2024-04-29 05:38:13
2024-04-29 18:06:45