How to get data from database in order?

Question

MySQL

Select * from tablename where model = 'A' or model = 'B'
with such a record, the result is unpredictable, 'B' can be found before 'A', the array is located like this ['B', 'A'], but you need [' A', 'B']

Answer 1

SELECT * FROM `table_name` WHERE `column_name` IN ('A', 'B', 'C') ORDER BY FIELD (`column_name`, 'A', 'B', 'C')

https://dev.mysql.com/doc/refman/8.0/en/string-fun...
https://dev.mysql.com/doc/refman/8.0/en/string-fun...

Answer 2

I don’t know if this is effective or not, but, it seems, I managed to solve it like this:
select * from tablename where model = 'A' union select * from tablename where model = 'B',
you need the order to be exactly as specified in the query