title: find exact word as part of a string
body: <p>I need to write a single SQL statement to list all the tracks that have the exact word 'right' (including both upper and lower cases) as part of the name in a table called Track. In other words, it will NOT include track names with words like 'rights' or 'righteous' in the output</p>
  
  <p>I wrote this but I keep getting words with letters before or after right eg: brighter or rights.</p>
  
  <pre><code>SELECT name
  
  FROM Track
  
  WHERE name LIKE "%right%";
  </code></pre>