title: Replace while matching in MySQL
body: <p>table <code>artists</code></p>
  
  <pre><code>id | name
  ---------
  1  | kida
  2  | capital t
  3  | taylor swift
  </code></pre>
  
  <p><br></p>
  
  <pre><code>select replace(name, ' ', '') from artists where match(`name`) against ('taylorswift' IN BOOLEAN MODE) limit 1
  </code></pre>
  
  <p>If I run this query it shows no result, but I want to replace space with null and show Taylor Swift as a result. Is this possible?</p>