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