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