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