Difference between #1 and #2 of
Using sub query for doubletts

Changes

Title unchanged

Using sub query for doubletts

Category unchanged

Tips

Yii version unchanged

Tags unchanged

active record, cdbcriteria, subquery, doubletts

Content changed

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.') ';
[...]
3 0
10 followers
Viewed: 25 534 times
Version: 1.1
Category: Tips
Tags: active record, cdbcriteria, doubletts, subquery
Written by: mb
Last updated by: mb
Created on: Aug 7, 2012
Last updated: 11 years ago
Update Article
Revert to #1 | Revert to #2

Revisions

View all history