Prisma

<@U0RQY0KK5> Can i apply filter query with like?

SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;

I dont want to match exact string

<@U5BE078UR> Yes, there are different filter arguments you can use, like:

```
allThings(filter: {name_contains: pattern}) {
  name
  otherStuff
}
```

If you go into the playground the autocomplete will show you the other potential filter arguments. They all follow the pattern of fieldName_condition

There any othere way for capital or small letter searching
"UserName"=="username"