Does MySQL support partial indexes? As @Gordon Linoff commented, MySQL does not (yet) support partial indexes.