title: Search and Replace Columns using Full Text Search Mysql
body: <p>Is there a way of running a Mysql Query using Full Text Search that will search a column for example (hayes) and replace the rest of the string with "hayes" once matched?:</p>
  
  <p>Column1:
  london, hayes, MD15 736</p>
  
  <pre><code>WHERE MATCH (COLUMN1) AGAINST ('hayes' IN BOOLEAN MODE)
  </code></pre>
  
  <p>Column1:
  hayes</p>
  
  <p>So since column 1 has matched "hayes" its removed the rest of the string. It needs to be done by full text as like for example takes too long on large data sets.</p>
  
  <p>And there is no set order where the keyword maybe so i cannot use <code>find_in_set</code></p>
  
  <p>Also i will running this with a large number of keywords like the below:</p>
  
  <pre><code>WHERE MATCH (COLUMN1) AGAINST ('hayes' IN BOOLEAN MODE)
  OR MATCH (COLUMN1) AGAINST ('+WEST +BROMWICH' IN BOOLEAN MODE)
  OR MATCH (COLUMN1) AGAINST ('London' IN BOOLEAN MODE)
  </code></pre>
  
  <p>So if i run the above query on a column1 which contains the following string: </p>
  
  <p><code>london, m456, hayes</code> &lt;&lt;&lt; it would match hayes ONLY and not both london and hayes.</p>