SELECT id FROM users WHERE active=1 AND about_me LIKE "%888642747%" ORDER BY username ASC, num_followers DESC
0.00899
SELECT id FROM users WHERE tags REGEXP "(^|\,| )888642747($|\,)" ORDER BY username ASC
0.01307
SELECT id FROM users WHERE active=1 AND (username LIKE "%888642747%" OR fullname LIKE "%888642747%" OR position LIKE "%888642747%") ORDER BY username ASC
0.01122
SELECT id FROM users WHERE active=1 AND (username="888642747" OR fullname="888642747" OR position="888642747") ORDER BY username ASC