php - 在接下来的第 4 列中查找 CI 数据库错误

Question

我有这个错误:

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'condition LIKE '%Chisel Round size: 120x3/440%')' at line 3

SELECT * FROM `inv_tool` WHERE (insert_date LIKE '%Chisel Round size: 120x3/440%' 
          || item_group LIKE '%Chisel Round size: 120x3/440%' || 
             item_name LIKE '%Chisel Round size: 120x3/440%' || 
             serial_number LIKE '%Chisel Round size: 120x3/440%' ||
             condition LIKE '%Chisel Round size: 120x3/440%')

Filename: D:/LocalWebServer/htdocs/ptes_is/application/models/Model_invsys.php

Line Number: 73

如果我使用超过 3 列来查找:

       public function find_in_tool ($find) {
            $this -> db -> where ("(insert_date LIKE '%$find%' || 
                           item_group LIKE '%$find%' || item_name LIKE '%$find%' || 
                         serial_number LIKE '%$find%' || condition LIKE '%$find%')");
            $query = $this -> db -> get ('inv_tool') ;
            return $query -> result () ;
        }

但是如果我只用3个，是没有问题的。

       public function find_in_tool ($find) {
            $this -> db -> where ("(insert_date LIKE '%$find%' || 
                         item_group LIKE '%$find%' || item_name 
                         LIKE '%$find%')");
            $query = $this -> db -> get ('inv_tool') ;
            return $query -> result () ;
        }

但我真的需要超过 3 ...

Answer 1

与列数无关，与MySQL/MariaDB保留关键字(条件)有关:https://dev.mysql.com/doc/refman/5.5/en/keywords.html

用反引号包裹您的列名和表名以避免冲突:

`condition` LIKE ...