3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php $sql = sprintf("SELECT ul.user_id, u.nickname, u.avatar ,u.intro, u.gender, u.points, ul.lng, ul.lat, ul.car_no FROM user_location ul INNER JOIN user u ON ul.user_id=u.id GROUP BY ul.user_id WHERE geohash LIKE '%s%%'", 'x'); echo $sql;
based on qHBnZ
Output for 4.3.0 - 7.1.0
SELECT ul.user_id, u.nickname, u.avatar ,u.intro, u.gender, u.points, ul.lng, ul.lat, ul.car_no FROM user_location ul INNER JOIN user u ON ul.user_id=u.id GROUP BY ul.user_id WHERE geohash LIKE 'x%'