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