Originally Posted by Miguel T

RLIKE is for REGEX matches.
You should update the query:

$result = mysqli_query($con,"SELECT * FROM Directory WHERE Category LIKE '%catfood%' LIMIT $offset, $total_records_per_page");