Home > DeveloperSection > Interviews > What is difference between SUBSTR and INSTR?

Posted on    January-31-2014 11:55 PM

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  1076  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    January-31-2014 1:00 AM

 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.


Don't want to miss updates? Please click the below button!

Follow MindStick