MySQL - Case Sensitivity in String Searches

When use query like "%XXX%",to cause a case-sensitive comparison of nonbinary strings to be case insensitive,

change collation of field to be case insensitive,eg utf8_general_ci

p/s: ci = case insensitive