Case Insensitive Query ?

also will that make sure it contains the whole thing or like if someones artist name was “Starboy” and one was “Star” would it not let them create “Star” is it contains Starboy or other way around etc…