Searching
Posted: Mon Apr 30, 2007 10:59 pm
Hi
I would like to know how to do searching in php and with the Mysql Data base support.
Usually we do the search by using "like" (%keyword%) in SQL query but this is limited to one string which the string has been passed to that query as a keyword.
What i want to know is how can we do a combinational keywords search. I mean in normal search we use only one key word to search the table. But how can we do a combinational search with multiple keywords and getting a good results perfectly with those keywords.
Please let me know or suggest me the way to do this.
Thank You very much.
Regards.
I would like to know how to do searching in php and with the Mysql Data base support.
Usually we do the search by using "like" (%keyword%) in SQL query but this is limited to one string which the string has been passed to that query as a keyword.
What i want to know is how can we do a combinational keywords search. I mean in normal search we use only one key word to search the table. But how can we do a combinational search with multiple keywords and getting a good results perfectly with those keywords.
Please let me know or suggest me the way to do this.
Thank You very much.
Regards.