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