RE: [PHP-DB] How to delete specific row in mysql table?

Your statement is saying: "if 3 is greater than 2, delete all" Your WHERE criteria should be based upon a specific field's contents, NOT its position in a data base -----Original Message----- From: Jan Grafström [mailto:jan@grafstrom.net] Sent: Tuesday, August 28, 2001 11:51 AM To: php-db@lists.php.net Subject: [PHP-DB] How to delete specific row in mysql table? Hi! I am new to this an wonder how to delete a row in my table. I have tryed with: ------ DELETE FROM mytable WHERE 3>2 ----- to delete row number 3 but all rows goes away! Thanks in advance for any help. Regards Jan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net