title: REGEXP_EXTRACT with String Value in Bigquery
body: <p>I want to extract words in a column, the column value looks like this:'p-fr-youtube-car'. And they should all be extracted to their own column.</p>
  <p><strong>INPUT</strong>:</p>
  <pre><code>p-fr-youtube-car
  </code></pre>
  <p><strong>DESIRED OUTPUT</strong>:</p>
  <pre><code>Country = fr
  Channel = youtube
  Item = car
  </code></pre>
  <p>I've tried below to extract the first word, but can't figure out the rest.What RegEx will achieve my desired output from this input? And how can I make it not case sensative fr and FR will be the same.</p>
  <p><code>REGEXP_EXTRACT_ALL(CampaignName, r&quot;^p-([a-z]*)&quot;) AS Country</code></p>