订购MySQL结果BY日期，也使用LIKE

Question

I have this table request with columns

request_id | users_ids | created

I need to get the results order by created, but get first the ones where user id do not exist inside users_ids.

Do i use something like FIELD() and NOT LIKE?

How do i do this?

Answer 1

ORDER BY IF(FIND_IN_SET('111', user_ids)>0,1,0),created

Where '111' is your user id. But, as Marc pointed in the comment to your question - you should avoid this by altering your schema design.