maria-developers team mailing list archive
Mailing list archive
Re: Partial indexes?
On Thu, Dec 28, 2017 at 9:34 AM, Sergei Golubchik <serg@xxxxxxxxxxx> wrote:
> In MariaDB (and in SQL standard) the way to achieve that
> would be to use a nullable column for active, and mark inactive users
> with NULL. Then you can create a unique index on (phone,active).
That is a neat trick, thanks James and Sergei!
Jared Beck • (607) 216-5373 • jared@xxxxxxxxxxxxx