Hi Everton one, I have the following search statement that works great, But what I would like to do is expand this to include multiple LIKE '%$search%'
$STM = $dbh->prepare('SELECT * FROM tblname WHERE col=:lsecure');
$STM->bindParam(':lsecure', $search);
$STM->execute();
$count = $STM->rowCount();
$results = $STM->fetchAll(PDO::FETCH_ASSOC);
What I would like to do is to add something like this to the select query.
WHERE description LIKE '%$search%' AND mcat LIKE '%$search%' AND scat LIKE '%$search%'
Any help would be greatly appreciated,