mysql 搜索语句

1、select * from wxb_miniapp_fastreg_log where (name like ‘%1%‘ or code like ‘%1%‘ or legal_persona_wechat like ‘%1%‘ or legal_persona_name like ‘%1%‘) and (status="0") order by createtime desc

2、select * from wxb_miniapp_fastreg_log where 1=1 and status="1" order by createtime desc

mysql 搜索语句

原文：https://www.cnblogs.com/ygyy/p/11337826.html