How to search an array element in SurrealDB

Question

I'm trying to perform a query that evaluates if an array includes or contains a specif value or set of values.

SELECT * FROM table WHERE data = ['value_a']

https://surrealdb.com/docs/surrealql/statements/select

I've read the documentation and try several queries, but I didn't find any function or way to create this query.

I've read the official documentation and performed several queries based on the examples, but nothing have worked.

https://surrealdb.com/docs/surrealql/statements/select

My expected behaviour is:

Matches a specific value or set of values like these examples in SQL relational database.

https://www.w3schools.com/sql/sql_in.asp

Answer 1

There is a CONTAINS operator : https://surrealdb.com/docs/surrealql/operators#contains

The Query should be like:

SELECT * FROM table WHERE data CONTAINS 'value_a'