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