How can I use fulltext search in graphql ? (without postresql function)

[kbrkiras]

I want to search name or surname with contains searchText :

$search=> "%Mike Adam%"

example:
_or: [{ name | ' ' | surname : { _ilike: $search } }]

Just I can do this:

_or: [{ name: { _ilike: $search } }, { surname: { _ilike: $search } }]

Can you help me ? is there solution without postresql function?

[productdevbook]

+1

[tirumaraiselvan]

Maybe this resource helps you? https://hasura.io/blog/full-text-search-with-hasura-graphql-api-postgres/