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