SELECT * FROM users WHERE $searchfield <= (
  SELECT MAX($searchfield) FROM users WHERE $searchfield < ?) 
ORDER BY $searchfield DESC 
LIMIT 1