how can I delete all records with the same date (by day, no time) that also has the same value for 1 other column.

Hi brihol44,

Try this:

DELETE from {mytable}
WHERE date (column) = '23/08/2013'
  AND othercolumn = 'something';

Select allOpen in new window

Good Luck,
Kent

Oh.  The data inside the string should conform to the format that you're using.

Kent

ok, I need to dynamically pull the date and something value and have mysql work for me not statically place 'something' or the date individually in the column. So if it's the date value wouldn't it be...

DELETE from {mytable}
WHERE date (column) = '%Y-%m-%d'
  AND othercolumn = 'something';

but wouldn't this statement also delete all records?

to be clear I just want to leave 1 record but delete all other duplicate records with the same date and othercolumn value = the same.

Ah.  Even easier.  (And you can use the primary_key in most any filtered delete.)  From the earlier description it appeared that the data didn't contain a primary key.


Kent

I guess i wasn't clear enough but the suggestion got me thinking in the right direction.