Hello people, I am new to MySQL (to all SQL, better said) and I am in need of some help.
I create a table with these characteristics: mysql> CREATE TABLE Usuarios (Nombre TEXT NOT NULL, -> Password TEXT NOT NULL, -> Permiso INT(1), -> PRIMARY KEY(Nombre(30))); Query OK, 0 rows affected (0.05 sec) This allows me to insert things like: INSERT INTO Usuarios (Nombre,Password) VALUES ('',''); I need to force those fields to have at least one letter or number, not empty, nor space. Is there a way I can do this, at least having it not empty?. Thank you very much. Regards, Gastón. --------------------------------------------------------------------- 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