RE: ORDER BY but disregard stop words

2007-10-16 Thread Jay Blanchard
[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

ORDER BY but disregard stop words

2007-10-16 Thread mysql
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? brian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]