i hava query written in java i want to use in iOS in objective-c and in sqlite my query

SELECT co.CompanyID as _id,co.CompanyName,co.Website,ci.CityName as City from CMP_Company co inner join LOC_City as ci on co.CityID = ci.CityID where co.CompanyName like '%"+value+"%' OR ci.CityName like '%"+value+"%' OR co.Website like '%"+value+"%' OR co.Email like '%"+value+"%' OR co.PhoneNo like '%"+value+"%' OR co.Mobile like '%"+value+"%' ORDER BY co.CompanyName