Good day
I am in need of a bit of help.
I need to do a partial match on a sqlselect
currently i have my code setup as follow
if(isset($_POST['Keyword'])) {
$p = $_POST['Keyword'];} else {$p=NULL;};
$sqlQuery = new SQLSelect();
$sqlQuery->setFrom('Products');
$sqlQuery->selectField('ID', 'ID');
$sqlQuery->addWhere(array('PartNumber' => $p ));
$SearchedProducts = $sqlQuery->execute();
currently it is searching for precise matches but that is not what i am looking for
I know i can modify
$Price=Products::get()->filter(
array(
'PartNumber:PartialMatch'=>$p,
));
but the way my code is set up it does not work with the filters
Any advice would be much appreciated
Thanks in advance
Skullies