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