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