Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
04-07-2013, 09:52 PM #1
- Join Date
- Dec 2005
- Thanked 76 Times in 76 Posts
string help - I can't see something
EDIT: Ok.figured it, forget this thread.
want all between '&url=' and '&ei='
why it is not working ?
set @str = 'http://www.google.hr/url?sa=t&rct=j&q=%22pardosa%20lugubris%22&source=web&cd=10&ved=0CHsQFjAJ&url=http%3A%2F%2Fhrcak.srce.hr%2Ffile%2F45457&ei=5n6tT6ymDNSN4gSKtamHDA&usg=AFQjCNGkzpsu5AwU34BdHoZTpJbHwnM4PQ&cad=rja'; set @p = locate('&url=',@str)+5;/*this part works*/ select MID(@str,@p, CHAR_LENGTH(@str)-locate('&ei=',@str)+4);