I am currently using this query for searching items in my database.
I'm wanting to step this up a notch, because now I'm doing 8 separate queries for each table in my database. Also, this is only searching for whole phrases, and I would like for it to search for whole phrases, as well as each individual word. I would then like it to order the results by relevance.
This is probably asking a lot. Is there a tutorial or something the explains an efficient way to accomplish this?
_______________
_brian.
Code:
SELECT * FROM links WHERE (description LIKE '%".$like."%' OR (plain_content LIKE '%".$like."%' AND plain_content <> '')) AND deleted <> '1' ORDER BY description ASCI'm wanting to step this up a notch, because now I'm doing 8 separate queries for each table in my database. Also, this is only searching for whole phrases, and I would like for it to search for whole phrases, as well as each individual word. I would then like it to order the results by relevance.
This is probably asking a lot. Is there a tutorial or something the explains an efficient way to accomplish this?
_______________
_brian.
