SELECT *
FROM employee
WHERE is_deleted != true
AND (:lastname IS NULL
OR lastname ILIKE '%'||lastname||'%'
OR :firstname IS NULL
OR firstname ILIKE '%'||:firstname||'%'
OR :middlename IS NULL
OR middlename ILIKE '%'||:middlename||'%');
我有一个全名列,我需要根据用户输入的内容(或姓氏和名字一起)按名字、姓氏或父源进行筛选.b告诉我如何实现