If user types in a word in the name column search i want it to search within the name and surname db column and tread these columns as one value.
Now in the search method I'm not sure how to accomplish this
be converted to something like
name LIKE '%".$this->name."%' OR surname LIKE '%".$this->name."%'using $criteria->compare
Any help will be highly appreciated