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