SQL trim wildcard pattern
<p>I have a quite large MySQL db table (posts) and in one field (post_text) there are a lot of old BB code that needs trimming.</p>

<p>This is one example of what i need to find:
<code>quote:1270ae936b</code>
(after : characters varies, always 10)</p>

<p>And replace with:
<code>quote:</code></p>

<p>How do i do this in SQL command?</p>

<p>Thanks in advance! :)</p>