Currently I have a table that has an action column that logs all the status changes of a particular listing. All the rows in this column follow the same format saying
Listing website status changed from Action to Publish. The listing ID is #1883.
There can be only 5 statuses which are: Publish, Action, Unpublish, Draft and Sold. I have now added 2 more columns in the database which are status_from and status_to. Here I want all the current records to fill in both the status_from which is Action in the above example and status_to which is Publish in the above example.
How do I make a query that can accomplish this task of getting the particular word out of an already existing entry in the row?
