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