By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,813 Members | 2,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,813 IT Pros & Developers. It's quick & easy.

How many methods of search and when where should use

100+
P: 160
Hi
i am looking for an article/link where i can study that how many methods are there for search in Mysql (for examle like(%),equal(=),full text search etc) and in which case which method is best. I will be very thankful to you if you guide me here or you send me a link to study. Thanks
Jul 9 '11 #1

✓ answered by Atli

Hey.

You basically have three options:
  • The typical boolean comparisons. Like: WHERE 'str' = field
  • Then there is the Pattern Matching operators. Those would be the LIKE and REGEXP operators.
  • And finally you can use the Full-text matching capabilities of the MyISAM engine.

If you need anything more complex/flexible than that, you would need to set up something on the side, like Sphinx.

Share this Question
Share on Google+
1 Reply


Atli
Expert 5K+
P: 5,058
Hey.

You basically have three options:
  • The typical boolean comparisons. Like: WHERE 'str' = field
  • Then there is the Pattern Matching operators. Those would be the LIKE and REGEXP operators.
  • And finally you can use the Full-text matching capabilities of the MyISAM engine.

If you need anything more complex/flexible than that, you would need to set up something on the side, like Sphinx.
Jul 10 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.