position(... IN ...) tells you the position of a string in another, starting at 1 and giving 0 for not found.
position(... IN ...)
position('he' IN 'hello');
That will return 1. If you want to ignore upper and lower case, use lower(str).
lower(str)