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