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