#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    6
    Rep Power
    0

    INSTR or LOCATE nth occurrence


    Hi,

    I want to know if it's possible to do a INSTR or a LOCATE in MySQL to return the position of the nth occurrence of a string. What I'm trying to do is to cut select substr of URL's and cut them at the third "/".

    Thanks in advance for you help !

    Suwbacca
  2. #2
  3. Transforming Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,180
    Rep Power
    9398
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    6
    Rep Power
    0

    Smile exactly !


    Works perfectly !

    Thanks a million.

IMN logo majestic logo threadwatch logo seochat tools logo