搜索表1 news 数据 条件:title like '%"& keyword &"%' or comapnyid in (select comapnyid from company where username like '%"& keyword &"%')
请问这in 这部分该如何查询?谢谢
...全文
374打赏收藏
请教ASP搜索问题,谢谢
模糊搜索 keyword 表1: news: newsID ,title , comapnyID 表2: company:comapnyID ,username 搜索表1 news 数据 条件:title like '%"& keyword &"%' or comapnyid in (select comapnyid from company where username like '%"& keyword &"%') 请问这in 这部分该如何查询?谢谢
select * from news where '"& keyword &"' like '%'+ title +'%' or
comapnyid in (select comapnyid from company where '"& keyword &"' like '%'+ username +'%')