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