title: SQL match first part of string and compare
body: <p>I use Oracle and MySql, so if you have any answer in both codes please let me know,</p>
  
  <p>Issue:</p>
  
  <p>I have 2 columns in one table called: USers</p>
  
  <p>Column#1= Names
  Column#2= UCNames</p>
  
  <p>This list contain names that are from different sources but partially match like:</p>
  
  <p><strong>Names</strong> </p>
  
  <hr>
  
  <p><strong>Alex</strong> Jones <strong>Marfex</strong></p>
  
  <p><strong>UCNames</strong></p>
  
  <hr>
  
  <p><strong>Alex</strong> Jonnes Mike <strong>Marfex</strong></p>
  
  <p>I want to compare both of the columns and find match based on the following attributes:</p>
  
  <p>Search on the <em>first</em> 4 for <em>letters</em> and 4 <em>last words</em> and to store in new column called: <strong>verifiyed</strong></p>
  
  <p>Thanks</p>