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