search

app-zap / PHPFramework

A lightweight PHP framework as a composition of different good features and concepts of other frameworks intended for easy use and fast development
Other
4 stars 1 forks source link

Use LIKE and mulitple values together #3

Closed smichaelsen closed 10 years ago

smichaelsen commented 10 years ago 
$where = ['title?' => ['wherelikemultipletest%', '%wheremultipleliketest']];
$this->db->select('item', '*', $where);`

This doesn't work at the moment because in SQL LIKE can not be used together with IN. Here's how the query has to look like: http://stackoverflow.com/questions/2318126/using-sql-like-and-in-together

The corresponding test is marked as incomplete.