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 

Answer 1

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

Please use this for further reference.

Answer 2

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