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