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