Subject: RE: ORDER BY but disregard stop words 2007-10-16 - By Jay Blanchard
Back
[snip]
Is there any way to use ORDER BY in such a way as to have it ignore
words such as "the", "a", "an", and the like?
[/snip]
I haven't tested this but you might be able to do it with a little REGEX
and a HAVING clause;
SELECT REGEX(words) AS undesirable
FROM table
HAVING stuff <> undesirable
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
