I would like to be able to use searches that seem somewhat intelligent.
Can you 'ORDER BY' number of matching 'OR' clauses? For example, someone
searches for "x y z", so I would do "select * from mytable where col1
like '%x%' or col1 like '%y%' or col1 like '%z%';", but I want it to
order by number of matches (so a match of y and z would turn up before a
match of just x).
If anyone has suggestions, or can point me to some reading, I would
really appreciate it. The only thing I can think of is a complicated
application-side program.
Thanks,
Jeff Davis