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