This question is for SQL

I apologise I do not have a test databse to upload.

I need help writing an SQL query that is able to do a key word$($s$)$ search and pull out associated data

For example I have a database that contains a number of different car models. Each of these models can have

an associated state to them $($Unscheduled$-$Maint, Scheduled$\_$Maint, Running, Scrapped$).$

The database also contains

a comments column that contains explanations behind each state change. The query will need to be able to search

this commments column for specific key words or phrases $($such as Engine failure or flat tire$)$ and pull out the associated

Model ID$,$ date$/$time of occurence, and state it was moved to$.$