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
20776
March 17, 2006 03:22AM
6729
March 17, 2006 07:34AM
3173
March 18, 2006 09:01PM
3927
June 20, 2007 02:54AM
Re: to solve the question
3791
June 20, 2007 04:05AM
3982
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.