Выборка значений из таблицы

CREATE TABLE CashOperation (
    cashOperationCode INT AUTO_INCREMENT PRIMARY KEY,
    `name` VARCHAR(25),
    parentCode INT,
    operationType INT,
    timeNorm VARCHAR(10),
    visitCond VARCHAR(10),
    FOREIGN KEY (parentCode)
        REFERENCES CashOperation (cashOperationCode)
);

INSERT INTO CashOperation (`name`) VALUES ('Обменные');
INSERT INTO CashOperation (`name`) VALUES ('Кредитные');
INSERT INTO CashOperation (`name`, parentCode) VALUES ('обмен долларов', 1);
INSERT INTO CashOperation (`name`, parentCode) VALUES ('обмен евро', 1);
INSERT INTO CashOperation (`name`, parentCode) VALUES ('Кредит месячный', 2);
INSERT INTO CashOperation (`name`, parentCode) VALUES ('Рассрочка без процентов', 2);

SELECT 
    *
FROM
    CashOperation
WHERE
    (parentCode IS NULL
        AND `name` LIKE '%Кред%' AND ...)
        OR (parentCode IS NOT NULL AND ...)

WITH co AS (
  SELECT cl.name ClassName, op.name OpName
  FROM 
    CashOperation cl 
    LEFT JOIN CashOperation op ON cl.cashOperationCode = op.parentCode
  WHERE
    cl.parentCode IS NULL
  UNION 
  SELECT cl.name ClassName, op.name OpName
  FROM 
    CashOperation op 
    JOIN CashOperation cl ON cl.cashOperationCode = op.parentCode
)
  SELECT OpName FROM co WHERE OpName LIKE '%Кред%' AND NOT EXIST (
    SELECT ClassName FROM op WHERE ClassName LIKE '%Кред%'
  ) 
  UNION
  SELECT ClassName FROM co WHERE OpName LIKE '%Кред%' AND NOT EXIST (
    SELECT ClassName FROM op WHERE ClassName LIKE '%Кред%'
  ) 
  UNION  
  SELECT ClassName FROM co WHERE ClassName LIKE '%Кред%'
  UNION
  SELECT OpName FROM co WHERE ClassName LIKE '%Кред%' AND OpName IS NOT NULL

WITH co AS (
  SELECT cl.name ClassName, op.name OpName
  FROM 
    CashOperation cl 
    LEFT JOIN CashOperation op ON cl.cashOperationCode = op.parentCode
  WHERE
    cl.parentCode IS NULL
 )