Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,960
    Thanks
    120
    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 ?
    Code:
    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);
    Last edited by BubikolRamios; 04-07-2013 at 10:38 PM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •