[ic] Custom sort algo, sort on filtered data, or concatenate two sorted queries?

Paul Jordan 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 mailing list