yuh様ありがとうございます。

頂いたコードを元に、

function process() {
if (defined("MOBILE_SITE") && MOBILE_SITE) {
$objView = new SC_MobileView();
} else {
$objView = new SC_SiteView();
}
$order = "random()";
$limit = "8";
$keyword = '特定の文字列';

$objQuery = new SC_Query_Ex();
$objProduct = new SC_Product_Ex();

$objQuery->setorder($order);
$objQuery->setlimit($limit);
$productids = $objQuery->getCol('product_id','dtb_products','del_flg = 0 AND status = 1 AND alldtl.comment3 ILIKE ?',array($keyword));
$$this->arrProducts = $objProduct->getListByProductIds($objQuery, $productids);


$objView->assignobj($this);
$objView->display($this->tpl_mainpage);


}


と書いてみましたが、


Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。
SQL: [SELECT product_id FROM dtb_products WHERE del_flg = 0 AND status = 1 AND alldtl.comment3 LIKE ? ORDER BY RAND() ]
MDB2 Error: no such field
_doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_21f065152d8168a5a747acf320e84f98ed16771851 FROM 'SELECT product_id FROM dtb_products WHERE del_flg = 0 AND status = 1 AND alldtl.comment3 LIKE ? ORDER BY RAND() LIMIT 0, 16']
[Native code: 1054]
[Native message: Unknown column 'alldtl.comment3' in 'where clause']

というエラーが出ます。

書き方が間違っているのでしょうか？