SELECT * FROM Table WHERE Column LIKE '_a_'The above code will generate results that has any one character before and after 'a' such as:
mac
cat
sad
SELECT * FROM Table WHERE Column LIKE '%[_]a[_]%'The above code will generate results such as:
in_a_house
she_is_a_mother
make_a_living
3 comments:
Great; thank you for the help!
Very handy, thank you.
Thanks - needed this. Obvious when you know...
Post a Comment