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