class.ilLikeLMContentSearch.php

Go to the documentation of this file.

<?php

declare(strict_types=1);
class ilLikeLMContentSearch extends ilLMContentSearch
{
    public function __createWhereCondition(): string
    {
        $concat = " content ";

        $and = "  WHERE ( ";
        $counter = 0;
        foreach ($this->query_parser->getQuotedWords() as $word) {
            if ($counter++) {
                $and .= " OR";
            }
            #$and .= $concat;
            #$and .= ("LIKE ('%".$word."%')");
            $and .= $this->db->like($concat, 'clob', '%' . $word . '%');
        }
        return $and . ") ";
    }
}