SELECT id FROM users WHERE active=1 AND about_me LIKE "%#TheLostRoom%" ORDER BY username ASC, num_followers DESC
0.00754
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#TheLostRoom($|\,)" ORDER BY username ASC
0.01040
SELECT id FROM users WHERE active=1 AND (username LIKE "%#TheLostRoom%" OR fullname LIKE "%#TheLostRoom%" OR position LIKE "%#TheLostRoom%") ORDER BY username ASC
0.00920
SELECT id FROM users WHERE active=1 AND (username="#TheLostRoom" OR fullname="#TheLostRoom" OR position="#TheLostRoom") ORDER BY username ASC