postgres concat two databse columns and search from there

SELECT * FROM employees
WHERE CONCAT(first_name, ' ', last_name) = 'John Doe';
Back