SELECT id FROM users WHERE active=1 AND about_me LIKE "%#t-shirts%" ORDER BY username ASC, num_followers DESC
0.00806
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#t\\-shirts($|\,)" ORDER BY username ASC
0.01084
SELECT id FROM users WHERE active=1 AND (username LIKE "%#t-shirts%" OR fullname LIKE "%#t-shirts%" OR position LIKE "%#t-shirts%") ORDER BY username ASC
0.00945
SELECT id FROM users WHERE active=1 AND (username="#t-shirts" OR fullname="#t-shirts" OR position="#t-shirts") ORDER BY username ASC