title: Regexp_extract everything after appearance of '-q_'
body: <p>Have strings containing 'q_' which I want to extract everything that comes after it. Some rows contain occurrence of q_ which I want everything that occurs after it. Example values in the column are: </p>
  
  <pre><code>prod-q_cat_trait_cat_social_issue
  _prod-q_body_modification_graffiti
  event_tickets
  dappled_grey
  _prod-q_cat_tech_support
  
  </code></pre>
  
  <p>What is wrong with my regular expression as I'm trying to remove the trailing '_' after q. </p>
  
  <pre><code>REGEXP_EXTRACT(queue_id, '[^q_]+$')
  </code></pre>
  
  <p>Is just returning</p>
  
  <pre><code>issue
  </code></pre>
  
  <p>I've also tried the split method:</p>
  
  <pre><code>SPLIT(queue_id, 'q_')[OFFSET(2)]
  </code></pre>
  
  <p>But this returns </p>
  
  <pre><code>Array index 2 is out of bounds (overflow)
  </code></pre>
  
  <p>Any suggestions. Thanks! (I am using Google Cloud SQL)</p>