I am looking for a way to search all deleted records in a table and undelete ones that were deleted by mistake. Anyone know of an easy way to do this? These are ISAM tables. Thanks.
By deleted records, do you mean they were deleted with: DELETE FROM tableName WHERE .... ? Or something like: UPDATE tableName set is_deleted = 1 WHERE ... ?If you deleted them logically, it's a matter of writing the correct SQL statement. If you deleted them physically, good luck, especially with MyISAM, unless you had binary logging turned on or backups...
-Matt
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
