How MySQL LOCATE() function is different from its synonym functions i.e. POSITION() and INSTR() functions?

As all of these functions are used to return the position of a substring within a string but LOCATE() function is a bit different from POSITION() and INSTR() function. In both POSITION() AND INSTR() functions, we cannot manage the starting position of search with the help of argument as position argument in LOCATE() function. All of these functions are having a difference in syntax also.

Rama Giri

Published on 20-Feb-2018 15:04:17