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