mysql 部分索引,在mysql中针对部分索引或过滤索引的解决方法？

I am using mysql db. I know postgresql and SQL server supports partial Indexing. In my case I want to do something like this:

CREATE UNIQUE INDEX myIndex ON myTable (myColumn) where myColumn <> 'myText'

I want to create a unique constraint but it should allow duplicates if it is a particular text.

I couldn't find a direct way to do this in mysql. But, is there a workaround to achieve it?

解决方案

I suppose there is only one way to achieve it. You can add another column to your table, create index on it and create trigger or do insert/update inside your stored procedures to fill this column using following condition:

if value = 'myText' then put null

otherwise put value

Hope it helps