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