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