title: MySQL remove string between brackets
body: <p>How to remove  characters between two brackets and brackets. For example</p>
  <pre><code>Let it [Am]be, let it [C/G]be, let it [F]be, let it [C]be
  [C]Whisper words of [G]wisdom, let it [F]be [C/E] [Dm] [C]
  </code></pre>
  <p>I want above string to</p>
  <pre><code>Let it be, let it be, let it be, let it be
  Whisper words of wisdom, let it be  
  </code></pre>
  <p>I tried below code but it is only remove first brackets.</p>
  <pre><code>REPLACE(lyric, SUBSTRING(lyric, LOCATE('[', lyric), LENGTH(lyric) - LOCATE(']', 
  REVERSE(lyric)) - LOCATE('[', lyric) + 2), ''))
  </code></pre>