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