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