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