title: Train test split mysql records into views
body: <p>how do i create two views, one for training data and the other for test data 70:30 split in mySql.</p>
  <pre><code>CREATE VIEW training_data
  AS
  SELECT Posts.post_content as post_content,
      CASE 
          WHEN (Posts.post_title like '%covid%corona%covid19%' or Posts.post_content like '%covid%corona%covid19%') THEN 1 
          ELSE 0
      END AS tag 
  FROM Posts;
  
  CREATE VIEW test_data
  AS
  SELECT Posts.post_content as post_content,
      CASE 
          WHEN (Posts.post_title like '%covid%corona%covid19%' or Posts.post_content like '%covid%corona%covid19%') THEN 1 
          ELSE 0
      END AS tag 
  FROM Posts;
  </code></pre>