GoFuckYourself.com - Adult Webmaster Forum - View Single Post

BestXXXPorn · 08-28-2009, 10:22 AM

From what you wrote (where x, y, and z are field names):

DELETE FROM `table` WHERE x >= 500 AND y>=(x * 0.95) AND z < x;

Might want to run a

SELECT * FROM `table` WHERE x >= 500 AND y>=(x * 0.95) AND z < x;

first to make sure you've got all the correct data in there... and I recommend backing up the table first too :P

08-28-2009, 10:22 AM
BestXXXPorn Confirmed User Join Date: Jun 2009 Location: Asheville, NC Posts: 2,277	From what you wrote (where x, y, and z are field names): DELETE FROM `table` WHERE x >= 500 AND y>=(x * 0.95) AND z < x; Might want to run a SELECT * FROM `table` WHERE x >= 500 AND y>=(x * 0.95) AND z < x; first to make sure you've got all the correct data in there... and I recommend backing up the table first too :P __________________ ICQ: 258-202-811 \| Email: eric{at}bestxxxporn.com Last edited by BestXXXPorn; 08-28-2009 at 10:23 AM..