title: Workaround in mysql for partial Index or filtered Index?
body: <p>I am using mysql db. I know postgresql and SQL server supports partial Indexing. In my case I want to do something like this:</p>
  
  <pre><code>CREATE UNIQUE INDEX myIndex ON myTable (myColumn) where myColumn &lt;&gt; 'myText'
  </code></pre>
  
  <p>I want to create a unique constraint but it should allow duplicates if it is a particular text.</p>
  
  <p>I couldn't find a direct way to do this in mysql. But, is there a workaround to achieve it?</p>