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