在SQL Server中使用多个AND和OR搜索全文本 [英] search full text with Mulitiple AND's and OR's in sql server

问题描述

嗨 我想用布尔运算符搜索全文本，而不仅仅是简单的AND和OR.
应该与多个AND和OR一起使用.
该标准必须采用以下格式:.net，开发人员和程序员，IT和软件，测试或管理人员，硬件或主管.

Hi I want to search full text with boolean operators not only simple AND and OR.
It should be With Mulitiple AND''s and OR''s.
That criteria must be in this format like .net and developer and programmer and IT and Software or testing or manager or hardware or director.

推荐答案

不明确，但以上是查询

Not clear but for above this will be the query

select * from Your [Table] where [yourColumnName]  like '%.net%' and 'developer' and  'programmer' and 'IT'
and 'Software' or 'Testing' or 'Manager' or 'Hardware' or 'director'

这篇关于在SQL Server中使用多个AND和OR搜索全文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！