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