MySQL Substring and Mid Parsing Bug

MySQL Substring and Mid Parsing Bug

References

Reference NO 1

http://stackoverflow.com/questions/13635173/mysql-substring-and-mid-parsing-bug

Reference NO 2

http://arriola-janu1991.blogspot.com/2013/08/mysql-substring-and-mid-parsing-bug.html

Reference NO 3

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html

Reference NO 4

http://bugs.mysql.com/bug.php?id=69836

Reference NO 5

http://www.tutorialspoint.com/mysql/mysql-string-functions.htm

Reference NO 6

http://blog.mclaughlinsoftware.com/2009/02/27/excel-string-parsing/

Reference NO 7

http://p2p.wrox.com/sql-server-2000/55581-parsing-string-using-charindex-substring.html

Reference NO 8

http://www.oldversion.com/windows/mysql-community-server-5-0-77