Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

Query including Match All Words, Match Any Words, and Exact Phrase Criteria

I am writing a query that can either have Match All Words, Match Any Words, and Exact Phrase criteria. I am little confused about Match All Words and Match Any Words. For Exact Phrase I know I have to use the '=' operator. But how will I differential between Match All Words, Match Any Words? Ans shouldnt Match All Words and Exact Phrase act the same?

Thanks, Nauman.
0
nauman_ahmed
Asked:
nauman_ahmed
  • 2
  • 2
1 Solution
 
vadim63Commented:
You can use
LIKE '%word%'
0
 
nauman_ahmedAuthor Commented:
Vadim63, I know about the like clause but how will you differential Match All Words and Match Any Words?

-Nauman.
0
 
vadim63Commented:
WHERE     (Something LIKE '%word1%') OR
                      (Something LIKE '%word2%')       -   for any word


WHERE     (Something LIKE '%word1%') AND
                      (Something LIKE '%word2%')       -   for all words
0
 
nauman_ahmedAuthor Commented:
THanks for the reply :)

-Nauman.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now