mercredi 1 avril 2015

SQL Check if a text contains a word

I have a Text,



'Me and you against the world' // false
'Can i have an email address' // true
'This is an' // true


I want to check whether the word an is inside my String.


How do I check if a text contains a specific word in SQL? I can't add a full-text catalog. Otherwies i could



SELECT * FROM TABLE WHERE CONTAINS(Text, 'an')

Aucun commentaire:

Enregistrer un commentaire