[thelist] simple sql question

Brian Cummiskey brian at hondaswap.com
Thu Nov 23 23:30:34 CST 2006


how do i re-write this as a DELETE statement instead of a SELECT?  I'm 
pruing out some duplicate files...


SELECT max(fileid) FROM files
GROUP BY title HAVING count(*) >1


Everytime i try to delete it via phpmyadmin on the X, it gives me the 
following error:


  Error

*SQL query:*

DELETE FROM `files` WHERE `files`.`max( fileid )` =563 LIMIT 1

*MySQL said: *

| #1054 - Unknown column 'files.max( fileid )' in 'where clause'



I'm not sure how to get around this.

Thanks!
|



More information about the thelist mailing list