468,242 Members | 1,601 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

search with AND boolean operator

10
Hi!
I am doing a search engine and I would like to make a search with the operator AND possible but I canīt find out how. Do I have to explode the phrase entered after each and" or does it exist an easier way to do that?
Thanks for your help
Raphaelle
Jun 13 '07 #1
4 1351
Motoma
3,237 Expert 2GB
Hi!
I am doing a search engine and I would like to make a search with the operator AND possible but I canīt find out how. Do I have to explode the phrase entered after each and" or does it exist an easier way to do that?
Thanks for your help
Raphaelle
You are on the right track Raphaelle. You will need to perform a level of parsing on the data you receive from the user. Am I correct in assuming you are using MySQL, or are you doing a search on something else?
Jun 13 '07 #2
shoonya
161 100+
nope dude
you have to explode it
eg
Expand|Select|Wrap|Line Numbers
  1. developer = abc and priority = high
is the query
Expand|Select|Wrap|Line Numbers
  1. select ** from *** where developer = abc INTERSECT select ** from **** where priority = high
Jun 14 '07 #3
pbmods
5,821 Expert 4TB
MySQL also supports boolean operators in fulltext searches.
Jun 14 '07 #4
ak1dnar
1,584 Expert 1GB
Hi!
I am doing a search engine and I would like to make a search with the operator AND possible but I canīt find out how. Do I have to explode the phrase entered after each and" or does it exist an easier way to do that?
Thanks for your help
Raphaelle
Have you solved this problem yet? could you please provide more details that describe how your user inputs looks like for the search criteria.
I think you are using a textbox input isn't it?.
Jun 17 '07 #5

Post your reply

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

Similar topics

16 posts views Thread by Shawnk | last post: by
1 post views Thread by Eric | last post: by
3 posts views Thread by kenny rullo | last post: by
nathj
3 posts views Thread by nathj | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.