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