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