Querying a Database for Matching Element in Array

awkcowell

I have a large database. One of my fields is an array of text. I could easily juggle it around to be an array of objects or an array of some other type if it helps. I am wondering how to query the database to return only records that contain a defined search element.

For example if a record had array: [text, dog, cat, fly], the record should be returned with this query. Thanks for any help!

Mihaly_Toth

I'd suggest looking into this thread, you may very well find the answer to your question there.

https://community.xano.com/discussion/4179693/counting-words-inside-a-list-of-text-in-multiple-objects