[RESOLVED] Characters last ?

MichaelHe

Is it possible to view a list from a database in alphabetical order, but with characters last.
Like this:

1
2
3
4
5
6
7
8
9
A
B
C
D
....
X
Y
Z
!
"
#
<
....

MichaelHe

Isn't there anybody with a good idea on this one :o)

NogDog

You'll probably have to write your own sorting algorithm and use it as the callback function of usort(), after storing the results from your query in an array.

MarkR

You may be able to create a custom collation? Read the MySQL documentation for more info.

Mark

Installer

There are probably better solutions, such as those already posted, but this should work:

sort($array);
foreach ($array as $key => $value) {
    $first = substr($value, 0, 1);
    if (!ctype_alpha($first) && !ctype_digit($first)) {
        $temp[] = $value;
        unset($array[$key]);
    }
}
$array = array_merge($array, $temp);

MichaelHe

What is ctype ??

I have on another site done something like this in the query:

ORDER BY case when Subkategori = 'Andet' then 1 else 0 end, Subkategori

and this

ORDER BY FIELD(Gruppe,'Musician','Singer','Composer','Studio Crew','Cover Crew')

In those examples I also list something in my own order, no alphabetical.
Can something like that be used in anyway maybe ??

MichaelHe

I have just found this one out...

in my query I write

ORDER BY case when substring(KundeNavn, 1, 1 ) between '0' and '9' or substring(KundeNavn, 1, 1 ) between 'a' and 'Z' then 0 else 1 end, KundeNavn

This will put everything between 0-9 and a-Z first, and all symbols before 0 and bewteen 9 and a will be place last.