Posted by frizzle on 09/26/88 11:30

Hi all,

I have a MySQL-table. 2 fields.
Field 1 -> Name
Field 2 -> Nick

Now i want to order them alphabetically by Nick,
BUT if Nick is empty it has to pick Name.
How can i mix both of them ?
(example below)

Thanks!

Greetings Frizzle.

-- example --
unordered:
Name | Nick
John | JohnnyBoy
Dean |
George | Jaws
Chris | Ape

result:
Ape
Dean
Jaws
Johnnyboy

• Next in forum: ereg_replace quastion
• Prev in forum: Re: idiot question about preg_match and regex
• Thread view: Order mixed columns?

[Reply to this message]