title: MySQL Regexp find href with space at the end
body: <p>There is a column in a MySQL table that stores HTML code.</p>
  
  <p>Unfortunately some link hrefs end with a space like</p>
  
  <pre><code>...some code...&lt;a href="/path/further-path/and-more-path "...&gt;some-text&lt;/a&gt;...some code...
  </code></pre>
  
  <p>Now I have to find each column row that have such a link in its content column.</p>
  
  <p>Tried some regexp select:</p>
  
  <pre><code>content REGEXP '.+href="[a-zA-Z0-9/\-][[:space:]]".+'
  content REGEXP '.+href="[a-zA-Z0-9/\-]( )".+'
  </code></pre>
  
  <p>With and without the .+ but none of them find anything that fits.
  I am sure that there are entries containing such links ;).</p>
  
  <p>Please help. I am not a regex guru at all.</p>