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 10:34:17

• Related Questions & Answers
• What is the difference between MySQL INSTR() and FIND_IN_SET() functions?
• What is the difference between MySQL LOCATE() and FIND_IN_SET() functions?
• Which MySQL functions work as similar as LOCATE() function?
• In MySQL, how CEILING() and FLOOR() functions are different from ROUND() function?
• What is RDBMS? Explain its major functions
• JavaScript encodeURI(), decodeURI() and its components functions
• Where is World Bank situated and what are its functions?
• Which function is a synonym of MySQL LENGTH() function?
• What is MySQL HEX() function and how it is different from CONV() function?
• In MySQL, how FIELD() function is different from FIND_IN_SET() function?
• How can I manage the start position of searching in MySQL LOCATE() function?
• Different Aggregation functions in SAP HANA
• How MySQL aggregate functions can be combined with MySQL IF() function?
• Mathematical Functions in Python - Special Functions and Constants
• Difference between regular functions and arrow functions in JavaScript