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