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