[TIP] Use COALESCE instead of nested IFNULL calls.

[jda]

>  > s = "select *,theDateSortMethod,COALESCE(authors, editors, title) as
>  > 'ff' from thereferences where hit>0 ORDER BY ff,theDateSortMethod"
>>
>>  and got the error:
>>
>>  Feature Not Supported
>
>This is because ORDER BY  ff present here, Jon.
>
>Remove ORDER BY to see how works COALESCE

That does not give the error.

Of course, the cursor isn't sorted, either... :-)

Jon