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