[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
'%red%'.
I think this solves the OP's question nicely IMO.
Paul
More information about the interchange-users
mailing list