php - Codeigniter 类似通配符

Question

当我想在 Codeigniter 中编写以下行时:

SELECT * FROM Customers WHERE City LIKE '%es%'; // CONTAINS 'es'

我写了这段代码:

$this->db->select('*');
$this->db->from('Customers');
$this->db->like('City', 'es');

您能帮我编写以下行的相关代码吗:

SELECT * FROM Customers WHERE City LIKE 'ber%'; // STARTS WITH 'ber'

这样它将显示以“ber”开头的城市的信息

Answer 1

您可以使用第三个参数来定义通配符的位置:

$this->db->like('City', 'es', 'after');
//SELECT * FROM Customers WHERE City LIKE 'ber%'

$this->db->like('City', 'es', 'before');
//SELECT * FROM Customers WHERE City LIKE '%ber'

$this->db->like('City', 'es', 'both'); //Default
//SELECT * FROM Customers WHERE City LIKE '%ber%'