Comparison Column has an array data with an array variable

One my Skills column for users table has array data like this

[‘php’,‘node’,‘java’,‘asp’]

Now I want to comparison this array With my Skills column and if have one Similar like PHP or java or node, I want to return the row

comparison this array [‘angular’,‘html’,‘php’] with my skills

Does anyone have the best solution?

1 Like

Something like this :

var arr = ["php", "node", "java", "asp"]
var skills = ["angular", "php"]

var temp = skills.filter(item => arr.includes(item)) 
// Output ["php"]
1 Like