select * from tbl where zz like '%55%' limit 5;

select * from tbl where zz like '%55%' and zz like '%66%' limit 5;

SELECT
  *
FROM (SELECT
    xxx.ID,
    xxx.UPCEAN,
    xxx.Name,
    xxx.CategoryName,
    xxx.BrandName,
    xxx.zz
  FROM xxx
  WHERE xxx.zz LIKE '%зяйст%' xx
WHERE xx.zz LIKE '%65%'

SELECT
  xxx.ID,
  xxx.UPCEAN,
  xxx.Name,
  xxx.CategoryName,
  xxx.BrandName,
  xxx.zz
FROM xxx
WHERE xxx.zz LIKE '%зяйст%'
AND xxx.zz LIKE '%65%'

WHERE xxx.zz LIKE '%зяйст%' AND xxx.zz LIKE '%65%'

CREATE TABLE uhtt.xxx (
  ID int(11) DEFAULT NULL,
  UPCEAN bigint(20) DEFAULT NULL,
  Name varchar(255) DEFAULT NULL,
  CategoryID int(11) DEFAULT NULL,
  CategoryName varchar(150) DEFAULT NULL,
  BrandID int(11) DEFAULT NULL,
  BrandName varchar(100) DEFAULT NULL,
  id_ int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  zz varchar(500) GENERATED ALWAYS AS (CONCAT_WS(' ', `Name`, `BrandName`)) VIRTUAL,
  PRIMARY KEY (id_)
)
ENGINE = INNODB,
AUTO_INCREMENT = 2925499,
AVG_ROW_LENGTH = 69,
CHARACTER SET utf8,
COLLATE utf8_general_ci;

ALTER TABLE uhtt.xxx
ADD INDEX IDX_xxx_UPCEAN (UPCEAN);

ALTER TABLE uhtt.xxx
ADD INDEX IDX_xxx_zz (zz);

EXPLAIN 
SELECT
 *
FROM xxx
WHERE xxx.zz LIKE '%зяй%'
AND xxx.zz LIKE '%65%'

EXPLAIN
SELECT
  *
FROM (SELECT
    *
  FROM xxx
  WHERE ((xxx.zz LIKE '%зяй%'))) xx
WHERE (xx.zz LIKE '%65%')

EXPLAIN 
SELECT
  xxx.ID,
  xxx.UPCEAN,
  xxx.Name,
  xxx.BrandName
FROM xxx
WHERE IF((xxx.zz LIKE '%зяйственн%'), IF((xxx.zz LIKE '%65%'), 1, 0), 0) = 1

SELECT COUNT(*), SUM(zz LIKE '%зяй%'), SUM(zz LIKE '%65%'), SUM(zz LIKE '%зяй%' AND zz LIKE '%65%')
FROM xxx 

SELECT
  *
FROM (SELECT
    *
  FROM xxx
  WHERE ((xxx.zz LIKE '%зяйственн%'))) xx
WHERE (xx.zz LIKE '%65%')

SELECT
    *
  FROM xxx
  WHERE xxx.zz LIKE '%зяйственн%' AND xxx.zz LIKE '%65%'

SELECT
  xxx.ID,
  xxx.UPCEAN,
  xxx.Name,
  xxx.BrandName
FROM xxx
WHERE IF((xxx.zz LIKE '%зяйственн%'), IF((xxx.zz LIKE '%65%'), 1, 0), 0)

SELECT
  xx.ID,
  xx.UPCEAN,
  xx.Name,
  xx.BrandName,
  xx.zz
FROM (SELECT
    xxx.ID,
    xxx.UPCEAN,
    xxx.Name,
    xxx.BrandName,
    xxx.zz
  FROM xxx
  WHERE ((xxx.zz LIKE '%зяйственн%'))) xx
WHERE (xx.zz LIKE '%65%')

SELECT
  xx.ID,
  xx.UPCEAN,
  xx.Name,
  xx.BrandName,
  xx.zz
FROM (SELECT
    xxx.ID,
    xxx.UPCEAN,
    xxx.Name,
    xxx.BrandName,
    xxx.zz
  FROM xxx
  WHERE ((xxx.zz LIKE '%зяйственн%'))) xx
WHERE (xx.zz LIKE '%65%')

 zz blob GENERATED ALWAYS AS (CONCAT_WS(' ', `Name`, `BrandName`)) STORED,

zz blob GENERATED ALWAYS AS (CONCAT_WS(' ', `Name`, `BrandName`)) VIRTUAL,

SELECT
...
FROM xxx WHERE (xx.zz LIKE '%65%зяйственн%')
 UNION
SELECT
 ...
FROM xxx WHERE (xx.zz LIKE '%зяйственн%65%')

SELECT
  xxx.ID,
  xxx.UPCEAN,
  xxx.Name,
  xxx.BrandName
FROM xxx
WHERE INSTR(xxx.zz, 'зяйственн')
AND INSTR(xxx.zz, '65')

SELECT
  xxx.ID,
  xxx.Name,
  xxx.BrandName
FROM xxx
WHERE xxx.Name  LIKE '%зяйственн%'
AND xxx.Name like '%65%'