LOCATE() FUNCTION in MySQL
LOCATE() FUNCTION The MySQL LOCATE function is used to get the location of the first appearance of a substring in a string. The various versions of MySQL support the LOCATE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23. Syntax: LOCATE( substring, string, start_position ) … Read more