union & ORDER BY?

Question

MySQL

Good time of the day!
There is a table:

id	name	good_name	payment
one	a	aa	true
2	b	bb	payment
3	c	cc	true

It is necessary to select paid companies and sort them by product (good_name), then unpaid ones go, and they must be sorted by company name (name).
Tried with union:

(SELECT * FROM `table` WHERE `payment`=&quot;true&quot; ORDER BY `good_name` ASC )<br/>
union<br/>
(SELECT * FROM `table` WHERE `payment`=&quot;false&quot; ORDER BY `name` ASC )<br/>

How can this perversion be realized?..
P.S. Thank you corrected the errors.

Answer 1

can it be easier

SELECT 
    *,
    IF(`payment`='true', `good_name`, `name`) prior
FROM `table` 
WHERE 
    `payment`="true" 
ORDER BY payment, prior

Answer 2

SELECT * FROM (
   SELECT * FROM `table` WHERE `payment`=="true" ORDER BY `good_name` ASC
) a
UNION
select * from (
   SELECT * FROM `table` WHERE `payment`=="false" ORDER BY `name` ASC 
) b

this will work, but you are right - this is a perversion

Answer 3

SELECT * FROM test ORDER BY payment, CASE WHEN payment = 1 THEN good_name ELSE NAME end

Answer 4

SELECT * FROM `table` ORDER BY `payment` DESC, `good_name` ASC

Answer 5

I can’t vouch for the syntax, but the meaning is simple - do Select from a generalized table using an additional field:

SELECT   id, name, good_name, payment
FROM     (SELECT   TOP (100) PERCENT id, name, good_name, payment, good_name AS ordr
            FROM     temp
            WHERE   (payment = 1)
            UNION
            SELECT   TOP (100) PERCENT id, name, good_name, payment, name AS ordr
            FROM     temp AS temp_1
            WHERE   (payment = 0)) AS t2_1
ORDER BY payment DESC, ordr
* This source code was highlighted with Source Code Highlighter.

Answer 6

and in which DBMS can/should one write WHERE `payment`=="true" instead of IS TRUE and even doubled equals? Please do not kick me - except for ORACLE, I have practically not seen anything over the past couple of years and I try to use ANSI as much as possible.
my version: SELECT t.*, decode(payment, true, good_name, name) as ord FROM table as t ORDER BY ord
is no better than IF/CASE