WHAT IS DIFFERENCE BETWEEN SUBSTR AND INSTR?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
MYSQL 
 1332  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is difference between SUBSTR and INSTR?

     INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence.SUBSTR function return a portion of string, beginning at character position, substring_length characters long.SUBSTR calculates lengths using characters as defined by the input character set.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!