MySQL Forums
Forum List  »  Newbie

How to convert function substrb from oracle to mysql
Posted by: Khanh asdasda
Date: June 19, 2017 08:38PM

I'm converting from oracle database to mysql database. I have a problem as bellow.
In oracle database using function substrb to returns a portion of string, beginning at a specified byte position, and a specified number of bytes long.
Example select substrb(account_name,1,2) from account;

But i don't find substrb in mysql. Everyone can help me convert it or write function in mysql to convert it. Thanks a lot.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.