Running Where Clause with Like Not Working

Try sth like this:

Code:

$builder = $db->table('contractors');
        $builder->like('contractor_id', $inputText);
        $builder->orLike('ccontact', $inputText);
        $builder->where('ccompanyId', $companyId);

     

use the "where" option in the end and start with like.

Thanks Demry. I tried this it still ignores the where clause irrespective of its position. This query returns contractor like it should but from all companies. I want it to search and return contractors associated with that company only.