LIKE运算符中的多个条件

Question

i am getting multiple values in this $languages like(php,Ruby) i want spilt that and how to check that split values in this query

SELECT * FROM software_capability where languages LIKE '%$languages%'

Answer 1

Try with this.

 SELECT * FROM table WHERE interests LIKE ('%sports%', '%pub%')

This is syntax. Exploded your $language and put each item in '%$item%'