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