Tech Pagination issue (Displaying RLIKE Results)

[Publisher Bucks]

Could someone possibly point me in the right direction as to why this query isnt showing the results that I want when adding a category but, it allows me to pull the full contents of the database and display them when no WHERE or RLIKE is present?

<?php
include('db.php');

if (isset($_GET['page_no']) && $_GET['page_no']!="") {
$page_no = $_GET['page_no'];
} else {
$page_no = 1;
}

$total_records_per_page = 10;
$offset = ($page_no-1) * $total_records_per_page;
$previous_page = $page_no - 1;
$next_page = $page_no + 1;
$adjacents = "2";

$result_count = mysqli_query($con,"SELECT COUNT(*) As total_records FROM `Directory`");
$total_records = mysqli_fetch_array($result_count);
$total_records = $total_records['total_records'];
$total_no_of_pages = ceil($total_records / $total_records_per_page);
$second_last = $total_no_of_pages - 1; // total page minus 1

$result = mysqli_query($con,"SELECT * FROM Directory LIMIT $offset, $total_records_per_page");
while($row = mysqli_fetch_array($result)){

echo "<p align=\"left\" class=\"style2\"><strong><a href=". $link .">". $row['Name'] ."</a></strong>";
echo "<p align=\"left\" class=\"style2\">". $row['Description'] ."</a>";
echo "<br />";

}
mysqli_close($con);
?>

I've tried adding the following to the query itself with no luck:

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

The amount of pages in the pagination changes, it just wont show the data when I add the WHERE Catergory RLIKE catfood part :/

What am I missing please?

[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");

[Publisher Bucks]

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");

*brainfart moment* Thank you