- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
Published on 20-Feb-2018 10:34:17
- Related Questions & Answers
- What is the difference between MySQL INSTR() and FIND_IN_SET() functions?
- Which MySQL functions work as similar as LOCATE() function?
- What is the difference between MySQL LOCATE() and FIND_IN_SET() functions?
- 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?
- How can I manage the start position of searching in MySQL LOCATE() function?
- In MySQL, how FIELD() function is different from FIND_IN_SET() function?
- How MySQL aggregate functions can be combined with MySQL IF() function?
- Different Aggregation functions in SAP HANA
- Mathematical Functions in Python - Special Functions and Constants
- How Are MySQL INSTR() and LIKE operator similar?
Advertisements