So I'm having trouble with my current search for a website. So my current search will achieve this; user inputs "crik" and it will return "cricket" for a search. However if a user inputs "crickets" it wont return "cricket" for a search. How do I get this to work? my current php code is;
$searchQ = $_GET['search'];
$ssss = $pdo->prepare('SELECT * FROM listing WHERE name LIKE :search');
$ssss->bindValue(':search', "%" . $searchQ . "%");
$ssss->execute();
I've also tried this but it didnt return anything;
$ssss = $pdo->prepare('SELECT * FROM listing WHERE MATCH(name) AGAINST (:search IN BOOLEAN MODE) ');