+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Orderby: uppercase Z > lowercase a (/showthread.php?tid=36440)
Orderby: uppercase Z > lowercase a - El Forum - 12-01-2010
[eluser]PeterGreffen[/eluser]
Hello,
An "ORDER BY" like ($this->db->orderby('name'));
gives me this result:
1. Adam
2. Zora
3. anna
4. zanzibar
5. ...
Seems like the uppercases are higher ranked than the lowercases...
Does anyone know how to solve this?
Thank you!
P.
Orderby: uppercase Z > lowercase a - El Forum - 12-01-2010
[eluser]n0xie[/eluser]
Google, first hit
Orderby: uppercase Z > lowercase a - El Forum - 12-01-2010
[eluser]PeterGreffen[/eluser]
N0xie, thanks.
I will use that solution, although I prefer to use the CI way of querying...$this->db->orderby(‘name’).
But thanks again!
P.
Orderby: uppercase Z > lowercase a - El Forum - 12-01-2010
[eluser]smilie[/eluser]
$this->db->orderby(‘LOWER "name"’)
Maybe... not tested :-)
Cheers,
Smilie
Orderby: uppercase Z > lowercase a - El Forum - 12-01-2010
[eluser]teampoop[/eluser]
Since it's a function, you want to put it in parens
Code:
$this->db->order_by('LOWER(name)');Orderby: uppercase Z > lowercase a - El Forum - 12-23-2010
[eluser]PeterGreffen[/eluser]
Thanks all!