GoFuckYourself.com - Adult Webmaster Forum

I have query that gets data from the database, processes that data, then deletes the original data, but I need help with the query to "delete only the data we just SELECTED".

Currently I have this

Code:

// Get data using query

SELECT bd_action,bd_target,SUM(bd_count) AS bd_count,bd_data FROM bd_action GROUP BY CONCAT(bd_data,bd_action,bd_target)



// Delete the data (actually just delete everything)

DELETE FROM bd_action

My problem is that when I add a "LIMIT 10000" to the original query, I need to add the same LIMIT to the delete statement

Modified but not working:

Code:

// Get data using query LIMIT 10000

SELECT bd_action,bd_target,SUM(bd_count) AS bd_count,bd_data FROM bd_action GROUP BY CONCAT(bd_data,bd_action,bd_target) LIMIT 10000



// ?? Delete the data that I just got (delete ONLY the stuff I just got in the previous query)

DELETE FROM bd_action WHERE (SELECT bd_action,bd_target,SUM(bd_count) AS bd_count,bd_data FROM bd_action GROUP BY CONCAT(bd_data,bd_action,bd_target) LIMIT 10000)

I can't find the right DELETE FROM query that will delete only those items I just queried.

Thoughts?