MySQL根据参数查询

set @param = '16039cd8-5442-4aa3-8fb6-aa21670af396';

select
@param;

select
pb.id,
pb.ParentId ,
pb.FullName
from
po_baseinfo pb
where
@param is null
or pb.Id = @param
or pb.ParentId = @param
order by
pb.FullName;

原文地址:https://www.cnblogs.com/Anthony518/p/15538504.html