Temp method sort question

[jda]

Hi Ruslan,

Another issue arose when considering the IFNULL sort I need to do.

All my fields are indexedbywords, so I have methods for sorting.

This query

select *,theDateSortMethod,COALESCE(authors,editors,title) as 'ff' 
from thereferences where hit>0 ORDER BY ff,theDateSortMethod

(when it works) will sort by ff, which is the field, not the sort 
method. Is this, then, the correct query

SELECT
 
*,theDateSortMethod,COALESCE(authorsSortMethod,editorsSortMethod,titleSortMethod) 
as 'ff'
FROM
    thereferences
WHERE
    hit>0 ORDER BY ff,theDateSortMethod

Thanks,

Jon