I'm new to SQL so I'm trying to learn it by creating a simple login page, I have in the database 3 users and I'm trying to make SQLite return true if it finds a match and nothing if it finds NULL.

This is the table called "users".

```
ID          username    password    recovery
----------  ----------  ----------  ---------- 
1           Admin       pass         476 
2           mod         pass123      928      
3           test001     12345        182     

```

This code works but it returns both NULL and true:

```
select case when username in ('mod') 
AND password = ('pass123') then true
else NULL end from users

```

What it does:

```
1    NULL
2    2
3    NULL

```

What I need it to do:

```
1   2

```

I tried many things like LIMIT and ORDER but I can't figure it out, any help please?