I am still learning MySQL and trying to find certain things I use to do in Access. I having been looking and can not find an way to set a field so that it can not be duplicated. Since I can not find that I tryed looking for the record using SELECT and WHERE but doing an IF on the result of the QUERY does not help.
Does anyone know how I can check for a duplicate in a database before adding a record. I am checking a text field for duplicate entry. Which means that I have to ignore case and spacing.
Thanks for any help.
Dee
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
