mysql query like compare character case insensitive code example
Example 1: javascript string search case insensitive
function stringContainsCaseInsensitive(search, subject){
return subject.toLowerCase().indexOf(search.toLowerCase()) !== -1;
}
stringContainsCaseInsensitive("red","We painted the room red.");//true
Example 2: php search in array case insensitive
array_search(strtolower($search), array_map('strtolower', $array));