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
My db structure:
oflags varchar(100) latin1_swedish_ci
My full query:
SELECT `nick`,`server`,`usermodes`,`oflags`,`timestamp` from `users_on` where `server` not like 'services%' AND `server` not like 'oper%' AND `server` not like 'blackbox%' ORDER BY binary FIELD(`oflags`,'N','a','A','C','o','O','h'), `usermodes`, `nick`