...

View Full Version : Resolved string help - I can't see something



BubikolRamios
04-07-2013, 09:52 PM
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);



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum