MySQL Forums
Forum List  »  Oracle

Re: to solve the question
Posted by: Roland Bouman
Date: June 20, 2007 04:05AM

LOCATE(substr,str,pos)

is almost what you need

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

In many cases, you need the position to excise a substring. for those cases, consider using SUBSTRING_INDEX(str,delim,count)

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

Options: ReplyQuote


Subject
Views
Written By
Posted
20717
March 17, 2006 03:22AM
6707
March 17, 2006 07:34AM
3158
March 18, 2006 09:01PM
3907
June 20, 2007 02:54AM
Re: to solve the question
3769
June 20, 2007 04:05AM
3930
July 11, 2007 02:52PM


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.