php - 查询不适用于 LIKE

Question

我正在尝试根据数据库中的某个字段进行查询。我正在尝试选择一个包含关键字字符串的单元格。LIKE 代码不起作用。错误代码如下:

无法运行查询:SQLSTATE[HY093]:参数编号无效:绑定(bind)变量的数量与标记的数量不匹配

PHP

$query = " 
            SELECT 1 
            FROM phpexcel
            WHERE objekt_nr = :objekt_nr && element_nr = :element_nr && element_scanned_where LIKE '%:element_scanned_where%'"; 

        $query_params = array(
            ':objekt_nr' => $ean_objekt_nr,
            ':element_nr' => $ean_element_nr,
            ':element_scanned_where' => $element_scanned_where
            );

Answer 1

试试这个:

$query = " 
            SELECT 1 
            FROM phpexcel
            WHERE objekt_nr = :objekt_nr && element_nr = :element_nr && element_scanned_where LIKE :element_scanned_where"; 

        $query_params = array(
            ':objekt_nr' => $ean_objekt_nr,
            ':element_nr' => $ean_element_nr,
            ':element_scanned_where' => '%'.$element_scanned_where.'%'
            );