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