SQL SELECT everything after a certain character <p>I need to extract everything after the last '=' (<a href="http://www.domain.com?query=blablabla">http://www.domain.com?query=blablabla</a> - > blablabla) but this query returns the entire strings. Where did I go wrong in here:</p> <pre><code>SELECT RIGHT(supplier_reference, CHAR_LENGTH(supplier_reference) - SUBSTRING('=', supplier_reference)) FROM ps_product </code></pre>