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

##</code><code>##

SELECT * FROM users 
WHERE $searchfield < ? 
ORDER BY $searchfield DESC 
LIMIT 1