CDBCriteria with FIND_IN_SET

Yii 1.1 General Discussion
1

Hi,

i’ve got 2 Tables.

offers:

id | category_id | text | title | valid_from

1 | 2,3,4 | test | testTitle | 2012-03-03

categories:

id | name |

2 | cat1 |

3 | cat2 |

4 | cat3 |

I want to join the 2 table by their category_id and got the following:

// select fields from offers-table

$oCriteria = new CDbCriteria();

$oCriteria->select = ‘category_id,text,title’;

$oCriteria->addCondition = ‘FIND_IN_SET()’;

$oCriteria->order = ‘valid_from DESC’;

How can I join the categories-table to this statement?

Thanks in advance!