Tag: mysql charindex function

MySQL INSTR Function

Example

Search for “3” in string “Iampsp.com”, and return position:

SELECT INSTR("Iampsp.com", "3") AS MatchPosition;

Definition and Usage

The INSTR() function returns the position of the first occurrence of a string in another string.

This function performs a case-insensitive search. Continue reading MySQL INSTR Function