SELECT
id,
name,
brief,
note
FROM prod_line.hb_param_pl_table
WHERE
lower(COALESCE(name, '')) LIKE '%взнос%'
OR lower(COALESCE(brief, '')) LIKE '%взнос%'
OR lower(COALESCE(note, '')) LIKE '%взнос%'
OR lower(COALESCE(name, '')) LIKE '%резерв%'
OR lower(COALESCE(brief, '')) LIKE '%резерв%'
OR lower(COALESCE(note, '')) LIKE '%резерв%'
OR lower(COALESCE(name, '')) LIKE '%собствен%'
OR lower(COALESCE(brief, '')) LIKE '%собствен%'
OR lower(COALESCE(note, '')) LIKE '%собствен%'
OR lower(COALESCE(name, '')) LIKE '%отчисл%'
OR lower(COALESCE(brief, '')) LIKE '%отчисл%'
OR lower(COALESCE(note, '')) LIKE '%отчисл%'
ORDER BY id;