比如LEFT JOIN drp_yctzd l ON a.djbh = l.lxdj OR l.bz LIKE %xxx%,
xxx为查询参数,具体的代码要怎么写?
LEFT JOIN drp_yctzd l ON a.djbh = l.lxdj OR l.bz LIKE '%${xxx}'
模糊查询-https://help.fanruan.com/finereport/doc-view-164.html