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