Hello, This link: https://www.prisma.io/features/databases advertise that Prisma supports full-text search, but in the docs, I don't find anything about this feature. In addition, I found this open issue related to the full-text search: https://github.com/prisma/prisma/issues/1183. Can anyone tell me about the availability of this feature? Thanks!

We do support

_contains

filter on string which you can use to search through texts. https://www.prisma.io/docs/prisma-client/basic-data-access/reading-data-JAVASCRIPT-rsc2/#basic-filters-for-lists

Hi @Harshit! Indeed, but, _contains don't implement the functionality of the SQL LIKE operator. When I use LIKE operator, doesn't matter if the string I'm searching for is lowercase or uppercase, it will return all the data that match with the string I provided for LIKE operator, without taking into account if string is lowercase or uppercase or whatever case. Thank you!

you are right @Andrei Bacescu,

_contains

is case sensitive, I just can't find my product a few minutes ago because its name is

Kem

and I searched

kem

🤣