this function returns 0. This function performs a case-insensitive search. LOCATE(substring - Eduguru

MySQL Function

LOCATE() – MySQL Function

May 16, 2020 eduguru LOCATE() - MySQL Function The LOCATE() function returns the position of the first occurrence of a substring in a string. If the substring is not found within the original string, String, this function returns 0. This function performs a case-insensitive search. LOCATE(substring

LOCATE() – MySQL Function The LOCATE() function returns the position of the first occurrence of a substring in a string.