syntaxe de like

on peut ecrire:

Code:

---

1 2	select * from table where (champ like %val1%) OR (champ like %val2%) OR .... OR (champ like %valn%)

---

est ce que il ya un syntaxe simplifier comme ceci:

Code:

---

1 2	select * from table where champ like (%val1% OR %val2% OR .... OR %valn%)

---

Pas à ma connaissance.

merci