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