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