title: Locate text position, extract text and insert in new column in MySQL
body: <p>I have the following example of rows in a MySQl table</p>
  
  <pre><code>              Column A    
  
  Row1    Lauguage=English&amp;Country=USA&amp;Gender=Male
  Row2    Gender=Female&amp;Language=French&amp;Country=
  Row3    Country=Canada&amp;Gender=&amp;Language=English
  </code></pre>
  
  <p>How can I achieve the following: For example, I need to look for Country</p>
  
  <ol>
  <li>I need to locate the position of Country in this text column. This changes from row to row.</li>
  <li>I need to then ignore the parameter 'Country=' and only extract the value. In some cases this will be NULL (like example in Row2) while in some rows I need the values followed by '=' (like example in Row1 &amp; Row3). But, I need to make sure I get the value only. Not the next parameter separated by '&amp;'</li>
  <li>Once I have extracted the values of the Country parameter, I need to create a new column where these values will now be extracted and stored.</li>
  </ol>
  
  <p>End Result: New Column</p>
  
  <pre><code>              Column B                                                
  
  Row1            USA                            
  Row2                              
  Row3           Canada                                  
  </code></pre>
  
  <p>Any help here would be appreciated! Thanks!</p>