查询结果中第一个的特定值(只有一个).按时间戳重新排序 [英] A specific value(only one) to be first in a query result. Rest order by time stamp

问题描述

我有一个帖子的搜索结果查询.我希望自己(userId = 27)写的帖子在查询结果中排在第一位，并按时间戳排序.任何人都可以在 mysql 中给我查询吗?

I have a search result query for posts. And I want posts written by myself(userId = 27) to be first in query result and rest ordered by time stamp. Can anyone give me query for that in mysql?

推荐答案

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

包含您的完整表架构帮助更好

include your full table schema help much better

这篇关于查询结果中第一个的特定值(只有一个).按时间戳重新排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！