in reply to Performing queries with DBI and DBD::MySQL
SELECT * FROM Prediction WHERE Prediction_id like '%keyword%'; [download]
By the way, you should definitely read up on placeholders before going any further.