数据库SQL语句

1、连表查询

`select resstatus.*,recruittext.* from resstatus join recruittext on resstatus.recruitid=recruittext.Id where recruitid in (${data.res}) and perid = ${data.userid}`

2、模糊匹配

`select * from recruittext where otitle like '%${search}%' or organame like '%${search}%'`

【多字段模糊匹配concat】

select * from ${collection} where CONCAT(${data}) like '%${search}%

3、在给定Id范围内查找，并根据这一范围排序

`select * from recruittext where Id in (${data}) order by field(Id,${data})

4、修改数据

`update wxpression set history="${newhis}" where userid=${userid}`

5、批量修改

`update resstatus set status=${data.status} where perid in (${data.list}) and recruitid=${data.optionid}`

6、新增

insert into setorgalist (createid,type) values ('${data.createid}','${data.type}'）

7、删除

`delete from resume where userid = ${id}`