SQL Order By, excluding 'the'

Register Sign In

SQL Order By, excluding 'the'

07-17-2008, 08:50 AM

[eluser]bradya[/eluser]
[quote author="xwero" date="1216323913"]

Code:
$this->db->order_by("REPLACE(bandname,'The ','')");

[/quote]

Thanks Xwero! Worked like a charm.

Messages In This Thread

SQL Order By, excluding 'the' - by El Forum - 07-17-2008, 08:37 AM

SQL Order By, excluding 'the' - by El Forum - 07-17-2008, 08:45 AM

SQL Order By, excluding 'the' - by El Forum - 07-17-2008, 08:50 AM