[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