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