如何做同义查询呢?如查询福建,则出现闽的也搜索出来.

[gyx999]

我想把同义词放在表table_keyword中,他们的wordID相同,表示同义
table_keyword
keyword wordID
福建 33
闽 33
广东 34
粤 34

select * from tableA where province in(select keyword where wordID=33
)
现在问题是我不想用in,我想用like的模糊查询.即只要出现过福建,闽的都找出来,那该怎么办呢?有没有什么高招!

[pengdali]

select * from tableA tem where exists(select 1 from table_keyword where tem.province like '%'+keyword+'%' and wordID=33)

[pengdali]

或：

select * from tableA tem where exists(select 1 from table_keyword where tem.province like '%'+keyword+'%' and wordID in (select wordid from table_keyword where keyword='福建'))

[pengdali]

或：

select * from tableA tem where exists(select 1 from table_keyword where charindex(keyword,tem.province)>0 and wordID=33)


charindex比like快

[wzh1215]

select * from tableA tem where wordID in (select wordID from table_keyword where province like '%'+keyword+'%')

[wzh1215]

select * from tableA where province in(select keyword from table_keyword where province like '%'+keyword+'%')

[gyx999]

to pengdali(大力 V3.0)
编译不能通过,
select * from tableA tem where exists(select 1 from table_keyword where tem.province like '%'+keyword+'%' and wordID in (select wordid from table_keyword where keyword='福建'))

你的'%'+keyword+'%' 中的keyword是字段名吗?

[gyx999]

wzh1215(四脚蛇)
table_keyword 中没有province字段啊

[pengdali]

编译错误？？你试了没有呀


create table table_keyword(keyword varchar(10),wordID int)
insert table_keyword values('福建', 33 )
insert table_keyword values('闽' , 33)
insert table_keyword values('广东' , 34)
insert table_keyword values('粤' , 34 )

create table tableA (province varchar(100) )

insert tableA values('asdf大力asdf')
insert tableA values('sadfasf福建sadfas')
insert tableA values('sdfgdg广东sdfas')
insert tableA values('sfasdfsa闽sdfass')



select * from tableA tem where exists(select 1 from table_keyword where tem.province like '%'+keyword+'%' and wordID in (select wordid from table_keyword where keyword='福建'))



go
drop table table_keyword,tableA

[pengdali]

province
----------------------------------------------------------------------------------------------------
sadfasf福建sadfas
sfasdfsa闽sdfass

（所影响的行数为 2 行）