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