Comparing
#1 with
#2
Content
at first find doubletts by db fields:
find doubletts by db fields.
in this example i will check doublets for 3 tabelfields (col1,col2,col3).
so i will get a subquery with the condition, select and grouping of the tablefields. the having with COUNT(<colname>) > 1 means: find all records more then one result.
```php[...]
get the subquery:
the subquery is a part of the query i need.
```php[...]
the "real" criteria with the subquery. you can add some criteria you need..
important: the number of col and the result of the subquery must be the same size!
add the subquery condition
and order by tablefields:
```php
$mainCriteria=new CDbCriteria();
$mainCriteria->condition=' (col1,col2,col3) in ('.$subQuery.') ';[...]
34k+
