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