I'm trying to knock up a search routine for a site I'm developing. I want to search two columns on one table (business name and business description).
If I search for example "timber decking", i want to return all records that have BOTH words (i.e 100% match) followed by all records that have either word in. I can do the logic for searching either BOTH or EITHER, but not BOTH AND EITHER.
Anyone have any tips or know any links to some tutorials,
Thanks in advance,
Jon
If I search for example "timber decking", i want to return all records that have BOTH words (i.e 100% match) followed by all records that have either word in. I can do the logic for searching either BOTH or EITHER, but not BOTH AND EITHER.
Anyone have any tips or know any links to some tutorials,
Thanks in advance,
Jon