INSTR()

INSTR() is a SQL function in the String Functions category. Returns the position of the first occurrence of substring in string. 0 if not found. The syntax is INSTR(string, substring). It accepts string, substring. It returns position integer. A typical example: SELECT INSTR('Hello World', 'World'); -- 7 SELECT * FROM products WHERE INSTR(name, 'Pro') > 0; A close relative is CONCAT(), which concatenates two or more strings into one string. Returns NULL if any argument is NULL. A close relative is SUBSTRING(), which extracts characters from a string starting at position `start` for `length` characters. A close relative is REPLACE(), which replaces all occurrences of `from_string` with `to_string` in a string. More about this category: String manipulation — CONCAT, SUBSTRING, REPLACE, TRIM, UPPER, LOWER, LENGTH. Related String Functions entries: CONCAT(), SUBSTRING(), REPLACE(), LENGTH(), TRIM(), UPPER(), LOWER(), LPAD() / RPAD().