Id  | name
---------------
1   |  clinker
2   |  gypsum

select * from table where name like '%$keyword%'

$keywordList = explode(' ', $keyword);
$sql = 'select * from table where ';
while (!empty($keywordList)) {
    $likeKeyword = array_shift($keywordList);
    $sql .= "keyword like '%{$likeKeyword}%'";
    if (!empty($keywordList))
        $sql .= " or ";
}
//...run your query here

select * from table where keyword like '%clinker%' or keyword like '%1%'