RAND 隨機讀取

回覆文章
yehlu
Site Admin
文章: 3245
註冊時間: 2004-04-15 17:20:21
來自: CodeCharge Support Engineer

RAND 隨機讀取

文章 yehlu »

select e.*,a.author,e1.php_name from e_news_articale e,author a,e_news_sub e1 where e.e_news_sub_id = e1.e_news_sub_id and e.author_id = a.author_id and e.homepage = 'Y' and state = 'Y' ORDER BY RAND() limit 0,1
回覆文章

回到「MySQL」