Or, if you want regex searching, look at mysql's "regexp" (or "regexp binary" for case insensitive):

select 
   'erix' regexp '[abc]',  --  returns 0
   'erix' regexp '[a-z]'   --  returns 1 
;
[download]