All pastes #205362 Raw Edit

lol

public text v1 · immutable
#205362 ·published 2006-10-16 19:13 UTC
rendered paste body
My query:
ORDER BY binary FIELD(`oflags`,'N','a','A','C','o','O','h'), `usermodes`, `nick`

My question:

I want to order oflags that it will sort like N first, then lowercase a, followed by A next up is C then its up to lowercase o and then uppercase O and last lowercase h