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