>>> SQL String Functions <<<<

--------------------------------------------------------------

--------------------------------------------------------------

Keys: LOCATE(), INSTR()

--------------------------------------------------------------

--------------------------------------------------------------

Website: LOCATE(find, str), INSTR(str, find)

https://www.dbload.com/articles/charindex-function-in-mssql-and-mysql.htm

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

1.

-- LOCATE(), INSTR() --

-- Find String Positions:

//MySQL LOCATE Function:

LOCATE():

Syntex:

LOCATE(substr,str)

LOCATE(substr,str,pos)

Examples:

SELECT LOCATE('a','An Apple',2)

SELECT LOCATE('a', NAME) FROM products;

//MySQL INSTR Function:

Syntex:

INSTR(str,substr)

Examples:

SELECT INSTR('An Apple','a');

SELECT INSTR(NAME, 'a') FROM products;

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------