search with AND boolean operator

[Phaelle]

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

[Motoma]

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?

[shoonya]

nope dude
you have to explode it
eg
[code=sql]developer = abc and priority = high[/code] is the query
[code=sql]select ** from *** where developer = abc INTERSECT select ** from **** where priority = high[/code]

[pbmods]

MySQL also supports boolean operators in fulltext searches.

[ak1dnar]

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?.