title: How to remove numbers in a string but keep the spaces in postgresql?
body: <p>So I have a column with the following values that some times has a number in the beginning</p>
  
  <pre><code>turtle boat
  10 banana split
  lord Thanos
  23 macbook
  </code></pre>
  
  <p>How to query to remove numbers and the space in front of the numbers, but not the space in the middle of the string?</p>
  
  <p><strong>Intended output:</strong></p>
  
  <pre><code>turtle boat
  banana split
  lord Thanos
  macbook
  </code></pre>
  
  <p>Query I tried from another question in here:</p>
  
  <pre><code>select regexp_replace(mycolumn, '[^[:alpha:]]', '', 'g')
  </code></pre>
  
  <p>Problem with this query is that it completely removes all spaces</p>