[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:


*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.


More information about the thelist mailing list