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