Hi Everyone!

Just got one question.

I'm trying to store e-mails in MySQL.

I know I can stor it as simple varchar, but I wanted to put some constraints on it.

Although I can't find any place, which give me some clear info on how to do it.

I though to do it like this

...
email varchar check(email in ('*@*.*'))
...;

Will it be correct or not? Is there a better way to do it?



P.S. For all those search Google adviser.

Please keep that advise for yourself. I ALREADY SEARCHED!

So unless you find something I didn't don't bother.



I'll go through the tutorial once again though. I might of missed something