How to check if is not null

Hello,

await db.query.users.findFirst({where: (users, { eq }) => eq(users.name, 'test')});

await db.query.users.findFirst({where: (users, { eq }) => eq(users.name, 'test')});

await db.query.users.findFirst({where: (users, { eq }) => eq(users.name, 'test')});

await db.query.users.findFirst({where: (users, { eq }) => eq(users.name, 'test')});

i want to find all users where name is not null. How to do in this situation?

Alex.dev•6/18/23, 10:26 AM

If I'm not mistaken there is special helper function for that. Check this out:
https://orm.drizzle.team/docs/operators#isnotnull

Filter and conditional operators – DrizzleORM

Drizzle ORM | %s

VonycOP•6/18/23, 3:54 PM

im trying it,

await db.query.users.findFirst({where: (users, { eq }) => and(eq(users.name, 'test'), isNotNull(users.name)});

await db.query.users.findFirst({where: (users, { eq }) => and(eq(users.name, 'test'), isNotNull(users.name)});

but it still return users without name :/ may be bug?

hisam•6/19/23, 4:59 PM

You can try to directly pass the SQLSQL part:

await db.query.users.findFirst({ where: and(eq(users.name, 'test'), isNotNull(users.name)) });

await db.query.users.findFirst({ where: and(eq(users.name, 'test'), isNotNull(users.name)) });

Note: I am not sure why you want to check the users.name = 'test'users.name = 'test' while also checking if the users.nameusers.name is not null. The first query should be enough (since

test

test

!= null)

await db.query.users.findFirst({ where: eq(users.name, "test") });

await db.query.users.findFirst({ where: eq(users.name, "test") });

How to check if is not null

Similar Threads

Similar Threads

Similar Threads