Hi guys, I want to search on multiple columns at the same time but I couldn't get it to work I tried

.textSearch("'title' | 'content'", "word")

.textSearch("'title' || 'content'", "word")

both didn't work

Hello @Foxmind1! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

The only way I've done is to create a calculated column of tsvector type like shown here: https://supabase.com/docs/guides/database/full-text-search#creating-indexes You don't have to do the index, but if more than just experimenting you should. Then you textSearch that column from js.

Searching on multiple columns

Ah i see now, thank you i will try it later.