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