NULL查询
whereIsNull()
可通过链式调用的方式来指定多条件的查询
- @param
field字段名
whereIsNull()
import { Db } from 'think-ts-db'
export default defineEventHandler(async (event) => {
const user = await Db('user', mysqlConfig).where('age', 10).whereIsNull('score').select()
return user
})import { Db } from 'think-ts-db'
export default defineEventHandler(async (event) => {
const user = await Db('user', mysqlConfig).where('age', 10).whereIsNull('score').select()
return user
})最终的SQL语句为：
SELECT * FROM user WHERE age = 10 AND score IS NULLSELECT * FROM user WHERE age = 10 AND score IS NULL