Delete records that contain a certain string
I'm completely new to this so please forgive me if this is the wrong place or a stupid question.
How I can delete all entries in a table that contain yesterdays date?
For example, an entry might read "Event 15 - 03-Jul-19 @ 18:45. K10/25B - Princethorpe" so on the 4th July I would like to delete it. I'm happy scheduling the in MyPHPAdmin but I need the SQL command.
This is in the database as one entire string though, not as a date field or anything so I need to be able to format yesterday's date as dd-mmm-yy and see if it is in the string. If it is, delete the record, if not, leave it.
I hope that makes sense.
Subject
Written By
Posted
Delete records that contain a certain string
June 24, 2019 03:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.