How to search an array of words in a text field

[183530]

Example:

TABLE 1

FIELD_TEXT

I like salty food and Italian food

I have Italian food

bread, rice and beans

mexican foods

coke, sprite

array

['italia', 'mex','coke']

match TABLE1 X ARRAY

Results:

I like salty food and Italian food

I have Italian food

mexican foods

is it possible to do in sql or pyspark?

[User16756723392]

A simple way

select FIELD_TEXT from TABLE 1 where FIELD_TEXT like 'italia' OR FIELD_TEXT like 'mex' OR FIELD_TEXT like 'coke'

[Meredithharper]

Yes, you can do it in SQL with LIKE or IN and in PySpark using array contains, ideal for filtering Words like halal catering Barcelona, catering, and many more

[trummy]

A simple way

select FIELD_TEXT from TABLE 1 where FIELD_TEXT like 'italia' OR FIELD_TEXT like 'mex' OR FIELD_TEXT like 'coke'