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