How to search across multiple columns and tables

Hi guys. For our app I want to implement a "global search". Basically a search field in the top nav bar where users can enter a (part of) a vendor / client / product / ... name / description / ID etc. It can be just a simple case-insensitive matching ala

LIKE

LIKE

LIKE

LIKE, doesn't have to be super smart.
What options do I have to implement this with Postgres / Supabase JS client?
The only thing that comes to mind is a

VIEW

VIEW

VIEW

VIEW with

UNION ALL

UNION ALL

UNION ALL

UNION ALL or similar. But then do something like this with Supabase JS client:

.or('like.id.%search string%, like.name.%search string%')

.or('like.id.%search string%, like.name.%search string%')

.or('like.id.%search string%, like.name.%search string%')

.or('like.id.%search string%, like.name.%search string%')

Any ideas are welcome!

How to search across multiple columns and tables

Similar Threads

Similar Threads

Similar Threads