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