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