Discussion Forum | Board Infinity

Structured query language

what is the difference between substr and substring function?

SUBSTR is the function from Oracle

SUBSTRING is the function from MySql
The SUBSTRING() function extracts some characters from a string.
for more details pls visit: https://www.w3schools.com/sql/func_sqlserver_substring.asp

sir you have said that substr function belongs to oracle but i have seen it in mysql documentation.
here is the link you can go for it-https://dev.mysql.com/doc/refman/8.0/en/string-functions.html.
and tell me which is right?

can you please solve this question?
here is the link-Structured query language select and group by.