LIKE with % on column names

postgresql sql-like

Try this

SELECT * FROM account_invoice,sale_orderWHERE sale_order.name LIKE '%'  || account_invoice.origin || '%'

% needs single quote because the pattern is a string.

|| is the operator for concatenation.

CodeHunter