title: Standard SQL: How to Extract Everything Before a Certain Character - Google BigQuery
body: <p>I have a database with a Landing Page column with different URLs from a website like you can see in the image below:</p>
  <p><img src="https://i.stack.imgur.com/3bfOE.pngg" alt="Text" /></p>
  <p>I want to keep the text from the beginning of the URL to the quotation mark before the non sense code at the end. How can I do this? Not sure if I can use Regex on SQL or how to do it.</p>
  <p>P.S.: I am working with Google BigQuery and standard SQL.</p>
  <p>Thanks!</p>