Wordpress search not looking for quoted text?

Question

WordPress

Hi all!
WordPress search does not search for text with quotes like:
set "Felika" in the search is not present
if removed, finds this text with quotes
set Felik
finds the product

Answer 1

Because it's not Google, the search looks for exact occurrences of words. If you make a typo, it won't find anything either. You can look towards elastic search or the ElasticPress plugin

Answer 2

It will be correct instead of type (0,1) to simply make the sum signed, positive - income, negative - expense. And then it will be:

SELECT `login`, SUM(IF(`sum` > 0, `sum`, 0)) AS `in`, 
       SUM(IF(`sum` < 0, `sum`, 0)) AS `out`, SUM(`sum`) AS `total`
    FROM `info_user`
    GROUP BY `login`

Answer 3

SELECT
  LOGIN,
  SUM(IF(TYPE=0, SUM, 0)) OUT_COME,
  SUM(IF(TYPE=1, SUM, 0)) IN_COME,
FROM 
  INFO_USER
GROUP BY 
  LOGIN

Answer 4

select a."login", sum(b."sum"), sum(c."sum)
from "info_user" as a
left outer join "info_user" as b on a."login"=b.login and b. type=0
left outer join "info_user" as c on a."login"=c.login and b.type=1
group by a."login"
not?