title: REGEXP word match
body: <p>I have a script where I am attempting to match a new jobtitle to an existing one in the database.</p>
  <pre><code>SELECT 
  a.title AS JobTitle,
  j.Description  AS MatchedJobTitle,
  f.Description      AS Family,
  p.ShortDescription AS ColourComplexity,
  j.IsCustomerFacing,
  j.JobTitleID
  FROM JobTitle j
  CROSS JOIN Staging.TMP_OC1 a
  INNER JOIN JobFamily f ON j.JobFamilyId = f.JobFamilyID
  INNER JOIN Pathways p ON f.PathwaysID = p.PathwaysID        
  WHERE a.title REGEXP CONCAT('([[:&lt;:]]|^)', j.Description, '[s]?([[:&gt;:]]|$)');
  </code></pre>
  <p>The Staging.TMP_OC1 table has one record which is the new job title, in this case Software Developer,USA.
  I would like to match it to the dbs existing job title which is 'software developer'.
  The regexp code above works for some job titles but not others.
  Please assist in developing a more comprehensive one.</p>
  <p>I am using mysql V8.</p>