mysql小技巧 用rand()寫隨機查詢

標籤：

if ($intelligent_count > 1) {
            //隨機抽取推薦菜單
            $intelligent = pdo_fetch("SELECT * FROM " . tablename($this->modulename . ‘_intelligent‘) . " WHERE name=:name AND weid=:weid AND storeid=:storeid AND id<>:id ORDER BY RAND() limit 1", array(‘:name‘ => $num, ‘:weid‘ => $weid, ‘:storeid‘ => $storeid, ‘:id‘ => $intelligentid));
        } else {
            $intelligent = pdo_fetch("SELECT * FROM " . tablename($this->modulename . ‘_intelligent‘) . " WHERE name=:name AND weid=:weid AND storeid=:storeid ORDER BY RAND() limit 1", array(‘:name‘ => $num, ‘:weid‘ => $weid, ‘:storeid‘ => $storeid));
        }

mysql小技巧 用rand()寫隨機查詢