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