本文介绍了如何执行多关键字搜索的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨... 我试图执行搜索操作... 但我想知道如何从多个关键字中搜索特定名称... 有可能吗?
hi... i have tried to perform the search operation... but i want to know how to search a particular name from multiple keywords... is it possible? can u give me an suggestion to do this operation.?
推荐答案创建一个包含搜索词的临时表,然后对表/列进行联接( s)您正在搜索. Create a temporary table that contains the search words, and then do a join on the table/column(s) you''re searching.
您始终可以在查询级别进行此搜索. 只需使用IN子句在Where中搜索名称. select * from table where name in (name1,name2) You could always do this search at the query level. Just search for a the names within the Where using an IN clause. select * from table where name in (name1,name2)
您也可以使用进行搜索 you can also search using, select * from tablename where columnname in (%value1%,%value2%,....);
谢谢 -amit.
thanks -amit.
更多推荐
如何执行多关键字搜索
发布评论