Query to delete pm's

[Spaz]

I need a query that will delete the pm's from a certain date in phpmyadmin so I don't have to manually click on delete on each one. Is there a way?

[TheIceman5]

yeah thats easy.

[Spaz]

Believe it or not that wasn't alot of help. Does anybody have a code they've used and worked that they would be willing to share with me?

[YappyDog]

What are "pm's"?

What is your table structure?

[barand]

Are you wanting to delete those records in a table where the time portion of a datetime field contains a time that is after 12:00 noon?

Or do you have a char field containing 'pm'.

If the latter, do you want to delete the characters 'pm' from the record or do you want to delete those records containing 'pm'?

Belive it or not, your question as it is, is not a lot of help

[trooper]

Spaz

Give us some more details then we'd love to help ya

😃

GM