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