sql全文检索问题
SELECT id from [business_info2] where contains(medicine_name,@search_title1 and @search_title2) order by id desc 语句老是报错
contains(medicine_name,@search_title1 and @search_title2)
说这种写法有问题。大家帮帮忙。。
SELECT id from [business_info2] where contains(medicine_name,@search_title1 and @search_title2) order by id desc 语句老是报错
contains(medicine_name,@search_title1 and @search_title2)
说这种写法有问题。大家帮帮忙。。
还是都是双引号呀。。
谢谢了。。
declare @b varchar(100)
set @a='Oakland'
set @b='Berkeley'
SELECT * from [authors]
where contains(city,'''+@a+'' or ''+@b+''')
where contains(medicine_name, '''+@search_title1+'' and ''+@search_title2+''') order by id desc
再帮想想
set @str='"'+@search_title1+'" and "'+@search_title2+'"'
SELECT id from [business_info2]
where contains(medicine_name, @str)
order by id desc