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