1 2 3 4 5 6 7 8 9 10 11
select * from test t where 1 = 1 /*IF SF.isNotEmpty(id) */ and t.id = /*id*/'' /*END*/ /*IF SF.isNotEmpty(name) */ and t.name = /*name*/'' /*END*/ order by t.id