SELECT id FROM users WHERE active=1 AND about_me LIKE "%#реалмадрид%" ORDER BY username ASC, num_followers DESC
0.00797
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#реалмадрид($|\,)" ORDER BY username ASC
0.01123
SELECT id FROM users WHERE active=1 AND (username LIKE "%#реалмадрид%" OR fullname LIKE "%#реалмадрид%" OR position LIKE "%#реалмадрид%") ORDER BY username ASC
0.00905
SELECT id FROM users WHERE active=1 AND (username="#реалмадрид" OR fullname="#реалмадрид" OR position="#реалмадрид") ORDER BY username ASC