MySQL - Order specific field values in multi column

Question

I have table like

+-----------+------------+------+------+------+
| id        | name       | col1 |col2  | col3 |
+-----------+------------+------+------+------+

I want order my table with two column like (col1, col2) in (v1,v1),(v2,v2)... and some other order.

In MySQL has ORDER BY FIELD(col1, 'v1', 'v2', 'v3') DESC, other columns ASC; but how using it in multi column like my example thanks.

Barmar · Accepted Answer · 2019-03-07 01:24:16Z

1

You can concatenate the strings.

ORDER BY FIELD(CONCAT(col1, ',', col2), 'v1,v1', 'v2,v2', ...)

answered Mar 7, 2019 at 1:24

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1