help me write this mysql query in codeigniter

hello check here https://codeigniter.com/user_guide/datab...ult-arrays

you dont have to translate the mysql query to CI query just do like this

$query = $this->db->query("SELECT *, ABS( post_code - 2015 ) AS distance FROM list_data WHERE business_name LIKE '%cash%' ESCAPE '!' ORDER BY distance LIMIT 6");