直奔我的脑袋,但是那又如何呢?
$input = 'Martin Smith';
$names = explode($input);
$this->db->select('*');
$this->db->from('users');
$this->db->where_in('firstname', $names);
$this->db->or_where_in('lastname', $names);
SELECT * FROM users
WHERE firstname IN ('Martin', 'Smith')
OR lastname IN ('Martin', 'Smith')