title: Mapping the selected value in MySQL
body: <p>I have 2 sets of data from two table , i need to join the table</p>
  
  <p>table_ 1</p>
  
  <pre><code>id     qid     choice               
  --------------------------
  11     2020     Item 1
  12     2020     Item 2
  13     2020     Item 14
  </code></pre>
  
  <p>table_2</p>
  
  <pre><code>rid    qid     question
  ---------------------------
  1001   2020    1.I love apple
  1002   2020    2.I love orange
  1003   2020    14.I hate lemon
  </code></pre>
  
  <p>Output </p>
  
  <pre><code>id    rid     qid     choice       question
  -------------------------------------------------
  11    1001    2020    Item 1      1.I love apple
  12    1002    2020    Item 2      2.I love orange
  13    1003    2020    Item 14     14.I hate lemon
  </code></pre>
  
  <p>The formate of the column "question" in table_2 must start with</p>
  
  <pre><code>1.XXXX , 2.XXXX , 14.XXXX until 20.XXXXXX
  </code></pre>
  
  <p>I think get the number before "." as the joining condition. But how to get the number or any other better solutions?</p>