Apply like function on an array is SQL Server

Question

I am getting array from front end to perform filters according that inside the SQL query.

I want to apply a LIKE filter on the array. How to add an array inside LIKE function?

I am using Angular with Html as front end and Node as back end.

Array being passed in from the front end:

 [ "Sports", "Life", "Relationship", ...]

SQL query is :

SELECT *
FROM Skills
WHERE Description LIKE ('%Sports%')

SELECT *
FROM Skills
WHERE Description LIKE ('%Life%')

SELECT *
FROM Skills
WHERE Description LIKE ('%Relationship%')

But I am getting an array from the front end - how to create a query for this?

Answer 1

In SQL Server 2017 you can use OPENJSON to consume the JSON string as-is:

SELECT *
FROM skills
WHERE EXISTS (
    SELECT 1
    FROM OPENJSON('["Sports", "Life", "Relationship"]', '$') AS j
    WHERE skills.description LIKE '%' + j.value + '%'
)

Demo on db<>fiddle