A specific value (only one) should be the first as a result of the request. Order balance on time

Question

I have a query for search results for posts. And I want the entries written by me (userId = 27) to be first in the query results, and the rest ordered by timestamp. Can someone give me a query for this in mysql?

Answer 1

select * from posts order by if (userid=27, -1, any_timestamp_include_zero); 

best to use your full table schema schema

Answer 2

How about something like:

 select * from post order by case when userid = 25 then '0001-01-01 00:00:00' else my_timestamp end 

(formatting part "0001-01-01" for MySql)

Answer 3

Something simple:

 SELECT * FROM POST WHERE userId = 25 UNION SELECT * FROM POST WHERE userId <> 25 ORDER BY TIMESTAMP_FIELD 

May work for your needs?