title: Regexp match domain and subdomain only from given domain in mysql
body: <p>This is what I got so far I'm getting some status to fail;</p>
  <p><a href="https://regex101.com/r/KuUS5L/1" rel="nofollow noreferrer">https://regex101.com/r/KuUS5L/1</a></p>
  <pre><code>[[:&lt;:]]lms.com[[:&gt;:]]
  </code></pre>
  <p>These are my expected status:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Keyword</th>
  <th>status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>lms.com</td>
  <td>1</td>
  </tr>
  <tr>
  <td>live.lms.com</td>
  <td>1</td>
  </tr>
  <tr>
  <td>live-lms.com</td>
  <td>0</td>
  </tr>
  <tr>
  <td>cssslms.com</td>
  <td>0</td>
  </tr>
  <tr>
  <td>lmsccc.com</td>
  <td>0</td>
  </tr>
  <tr>
  <td>lms.com.ph</td>
  <td>0</td>
  </tr>
  <tr>
  <td>lms.com.edu</td>
  <td>0</td>
  </tr>
  </tbody>
  </table>
  </div>
  <pre><code>SELECT 
  *
   FROM
  (SELECT 
      SUBSTRING_INDEX(email, '@', - 1) AS substrEmail1,
      email
  FROM
      members m1) AS d
   WHERE d.substrEmail1 regexp '[[:&lt;:]]gs.com[[:&gt;:]]';
  </code></pre>