<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Most of my data in a row called 'mtaName' is labelled like this:<br />
<br />
&quot;test.com - G1 - 10-11-2011&quot;<br />
&quot;test2.com - G2 - 09-11-2011&quot;<br />
<br />
etc..<br />
<br />
What I want, is a method to remove anything past the second '-' So taking the example above:<br />
<br />
&quot;test.com - G1&quot;<br />
&quot;test2.com - G2&quot;<br />
<br />
Without the date pretty much and the extra '-'. Is this possible at all? I know of regexp but not how to use it in this context.<br />
<br />
Thank you!
</div>
</div>


Hello,

Most of my data in a row called 'mtaName' is labelled like this:

"test.com - G1 - 10-11-2011"
"test2.com - G2 - 09-11-2011"

etc..

What I want, is a method to remove anything past the second '-' So taking the example above:

"test.com - G1"
"test2.com - G2"

Without the date pretty much and the extra '-'. Is this possible at all? I know of regexp but not how to use it in this context.

Thank you!

MYSQL Query to remove anything after a second '-' including the '-'

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.