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