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