Column not found problem

Yii 1.1 General Discussion
1

With the code:




$sql = "SELECT word, question FROM tbl_words WHERE groupid=ex";               

$row = Yii::app()->db->createCommand($sql)->queryAll();

print_r($row);

i get the following error




CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ex' in 'where clause'. The SQL statement executed was: SELECT word, question FROM tbl_words WHERE groupid=ex
2

ex should be within quotes

$sql = “SELECT word, question FROM tbl_words WHERE groupid=‘ex’”;