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