hi..

Can anyone help me to know the function to be used to extract a substring from a string in MySQL?

regards..

SUBSTRING() & SUBSTRING_INDEX() are available in MySQL, you can see the spec on this page: http://dev.mysql.com/doc/mysql/en/string-functions.html

hi
you can use substring(a,b);where a is the starting index from where you want the string and b is the end of that substring.
let me know whether it worked.