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