SQL SELECT everything after a certain character

Question

I need to extract everything after the last      http   www domain com query blablabla -   blablabla  but this query returns the entire strings  Where did I go wrong in here   SELECT RIGHT supplier reference  CHAR LENGTH supplier reference  - SUBSTRING      supplier reference    FROM ps product

User · Answer

I ve been working on something similar and after a few tries and fails came up with this   Example  STRING-TO-TEST-ON    ab cd ef gh   I wanted to extract everything after the last occurrence of      comma  from the string    resulting in  gh    My query is   SELECT SUBSTR  ab cd ef gh  FROM  LENGTH  ab cd ef gh   -  LOCATE     REVERSE  ab cd ef gh   -1  1   AS  wantedString    Now let me try and explain what I did       I had to find the position of the last     from the string and to calculate the wantedString length  using LOCATE     REVERSE  ab cd ef gh   -1 by reversing the initial string I actually had to find the first occurrence of the     in the string     which wasn t hard to do     and then -1 to actually find the string length without the      calculate the position of my wantedString by subtracting the string length I ve calculated at 1st step from the initial string length    LENGTH  ab cd ef gh   -  LOCATE     REVERSE  ab cd ef gh   -1  1   I have   1  because I actually need the string position after the last        and not containing the      Hope it makes sense    all it remain to do is running a SUBSTR on my initial string FROM the calculated position    I haven t tested the query on large strings so I do not know how slow it is  So if someone actually tests it on a large string I would very happy to know the results

User · Answer

In MySQL  this works if there are multiple     characters in the string  SUBSTRING supplier reference FROM  LOCATE     supplier reference  1     It returns the substring after  1  having found the the first

User · Answer

select SUBSTRING INDEX supplier reference     -1  from ps product    Please use http   www w3resource com mysql string-functions mysql-substring index-function php for further reference

User · Answer

For SQL Management studio I used a variation of BWS  answer  This gets the data to the right of      or NULL if the symbol doesn t exist      CASE WHEN  RIGHT supplier reference  CASE WHEN  CHARINDEX     supplier reference 0     0 THEN     0 ELSE CHARINDEX      supplier reference  -1 END    lt  gt     THEN  RIGHT supplier reference  CASE WHEN  CHARINDEX     supplier reference 0     0 THEN     0 ELSE CHARINDEX      supplier reference  -1 END   ELSE NULL END

User · Answer

Try this  it should work if there are multiple     characters in the string    SELECT RIGHT supplier reference   CHARINDEX     REVERSE supplier reference  0  -1  FROM ps product

User · Answer

Try this in MySQL   right field   CHAR LENGTH field  - InStr field

[mysql] SQL SELECT everything after a certain character

Examples related to mysql

Examples related to sql

Examples related to substring

Examples related to string-length