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