You are correct. That is an application-side rule that you will need to enforce using your application code. MySQL could possibly do this check but the overhead involved would be severe and your application's performance would suffer.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Jonathan Jesse" <[EMAIL PROTECTED]> wrote on 10/10/2004 04:35:30 PM: > As mentioned previously I am a MySQL newbie. I have read most of the Paul > DuBois book and portions I have found relevant of the manual to help me out, > however I have not found an answer to this question, maybe it is not even > needed. > > I have used MS Access a lot and one of the ways I use it is to track > hostname to username to ip address at work. In the forms we have a > validation rule on the field ip address which allows only numbers in > XXX.XXX.XXX.XXX format. Is there such a way to do this in MySQL or would > that be on the application that I would use to open/insert/etc ? > > Thanks in advance, > > Jonathan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >