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