-
sort odd/even
From
vjp2.at@vjp2.at@at.BioStrategist.dot.dot.com to
comp.databases.mysql on Fri Jan 10 11:42:02 2020
From Newsgroup: comp.databases.mysql
order by street, house, if(mod(right(trim(house),1),2)=0,0,1)
I printed out mod(..) and it is ok but it won't sort by it
is it possible it only sorts on two and no more keys?
It worked on Microsoft
Tried several variants
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
--- Synchronet 3.21d-Linux NewsLink 1.2
-
From
vjp2.at@vjp2.at@at.BioStrategist.dot.dot.com to
comp.databases.mysql on Fri Jan 10 12:04:12 2020
From Newsgroup: comp.databases.mysql
Tried concat the three fields and still same
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
--- Synchronet 3.21d-Linux NewsLink 1.2
-
From
vjp2.at@vjp2.at@at.BioStrategist.dot.dot.com to
comp.databases.mysql on Fri Jan 10 12:11:19 2020
From Newsgroup: comp.databases.mysql
Got it to work by using only first three chars of house and street.
Kinda lame, but it worked.
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
--- Synchronet 3.21d-Linux NewsLink 1.2