in reply to Performing queries with DBI and DBD::MySQL

You need to use 'like', eg:
SELECT * FROM Prediction WHERE Prediction_id like '%keyword%';

The '%' is effectively a wildcard here.

By the way, you should definitely read up on placeholders before going any further.