How to sort the result of a query by a column where there is a value in another column in the same table?

Question

How to sort the result of a query by a column where there is a value in another column in the same table?

Navigation

#1 by (1 votes)

0

I have a table with several columns, and I want to sort the results by the values of one of the columns where another column in the same table is equal to a value.

I have already tried to implement the query with CASE , IF's and FIELD() .

I want the results sorted by tech.value when tech.id_color = 5

Here is the query:

SELECT DISTINCT * 
FROM products, tech_products 
WHERE products.idsub = 1 AND 
    tech_products.id = products.id 
ORDER by tech.id_cor = 5 AND tech.value ASC

sql select value

asked by anonymous 18.05.2018 / 16:52

1 answer

How to use async / await in get request using vue + axios? How to keep the sonic inside the screen ?, n coming out from the sides

score 1 · Accepted Answer

SELECT DISTINCT * 
FROM products, tech_products 
WHERE products.idsub = 1 AND 
    tech_products.id = products.id 
ORDER by (case when (tech.id_cor = 5) then 0 else 1 end) ASC,
         tech.id_cor

The syntax of CASE may vary depending on the DB, but I think it works out.