MySQL SQL SELECT everything after a certain character

SELECT RIGHT(supplier_reference, CHAR_LENGTH(supplier_reference) - SUBSTRING('=', supplier_reference)) 
FROM ps_product

 

해결 방법

 

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

 

참조 페이지 https://stackoverflow.com/questions/19495427