Workaround in mysql for partial Index or filtered Index?
Filtered indexes could be emulated with function indexes and CASE expression(MySQL 8.0.13 and newer): CREATE TABLE t(id INT PRIMARY KEY, myColumn VARCHAR(100)); — NULL are not taken into account with `UNIQUE` indexes CREATE UNIQUE INDEX myIndex ON t((CASE WHEN myColumn <> ‘myText’ THEN myColumn END)); — inserting excluded value twice INSERT INTO t(id, myColumn) VALUES(1, … Read more