CODE EXAMPLE FOR SQL

mysql listing get a particu particular user firsdt

SELECT userid, name FROM users WHERE nationality="US" ORDER BY FIELD(user_id,101) DESC, name asc