mysqlsqlsubstringstring-length

SQL SELECT everything after a certain character


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

Solution

  • select SUBSTRING_INDEX(supplier_reference,'=',-1) from ps_product;
    

    Please use this for further reference.