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