I'm trying to perform a search for records that contain a string of
characters anywhere that they might appear in a VARCHAR field.
Currently I'm using LIKE('%mystring%') to perform the search. This
works well except that the search needs to be case insensitive. Is
there a way to make LIKE case insensitive or is there a better way to
do this?