Help displaying not not values first

[tunage]

Hi, is there a way that i can query my datatabse and it will display the not null values in order, then display the null values?

This is my code so far-

$orderby = "clientOrderNo, orderID";

$query = "SELECT co.orderID, c.forename, c.surname, c.organisation, co.orderDate, co.clientOrderNo
	FROM client_order as co left join client as c on co.clientID = c.clientID
	where co.clientID = c.clientID
	order by $orderby";

So that it will display by client order number, then the null values by order number.

Thanks in advance.

[Lars_Berg]

$orderby = " case when clientorderNo is null then 1 else 0 end,clientOrderNo, orderID";

[tunage]

Thanks Lars, nearly did it just has to order descending -

$orderby = " case when clientorderNo is null then 1 else 0 end,clientOrderNo desc, orderID";

😃