On Thu, Dec 28, 2017 at 9:34 AM, Sergei Golubchik <s...@mariadb.org> 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 • ja...@jaredbeck.com _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
