[ic] Custom sort algo, sort on filtered data, or concatenate two sorted queries?
paul at gishnetwork.com
Thu Jan 28 03:49:11 UTC 2010
>> If you just want to do precisely what you stated, which is not precisely
>> weighted, you could just create a new return result that is a 1 if the
>> first part of the string is 'red', then sort descending.
> This is easy. Just do:
> ORDER BY color LIKE 'red%' DESC
Oh, yeah :-)
I think that is what Angus meant to suggest. He suggested the same thing but
I think this solves the OP's question nicely IMO.
More information about the interchange-users