Login

07-20-2009, 03:58 PM

[eluser]slowgary[/eluser]
You can generate the query manually, but still using CodeIgniter. Do this like so:

Code:
$this->db->query("

SELECT *

FROM (`db_stores`)

WHERE `UPS` = '1'

AND  (`store_zip`  LIKE '90266%'

OR  `store_zip`  LIKE '�266%'

OR  `store_zip`  LIKE '�267%'

OR  `store_zip`  LIKE '�254%'

OR  `store_zip`  LIKE '�278%'

OR  `store_zip`  LIKE '�245%'

OR  `store_zip`  LIKE '�261%'

OR  `store_zip`  LIKE '�260%'

OR  `store_zip`  LIKE '�251%'

OR  `store_zip`  LIKE '�250%'

OR  `store_zip`  LIKE '�506%'

OR  `store_zip`  LIKE '�503%'

OR  `store_zip`  LIKE '�304%'

OR  `store_zip`  LIKE '�009%'

OR  `store_zip`  LIKE '�277%'

OR  `store_zip`  LIKE '�504%'

OR  `store_zip`  LIKE '�083%'

OR  `store_zip`  LIKE '�080%'

OR  `store_zip`  LIKE '�249%'

OR  `store_zip`  LIKE '�045%'

OR  `store_zip`  LIKE '�307%')"

)->result();

How do you determine which numbers to put into your OR clauses?