กระดานแสดงความคิดเห็น

SQL Sample
SELECT * FROM tot ORDER BY dtime DESC LIMIT 60 , 30; áÊ´§Ë¹éÒÅÐ 30 àÃÔèÁ 60
Truncate table tot;
SELECT * FROM tot WHERE left( url, 1 ) = "w" LIMIT 0 , 30; áÊ´§Ë¹éÒÅÐ 30 àÃÔèÁ 60
SELECT * FROM tot WHERE right( url, 1 ) = "/";
delete FROM tb1 WHERE right( url, 1 ) = "/";
select url as urlg,count(url) as x from tb11 group by url;
select url as urlg,count(url) as x from tb11 group by url order by x desc;
select * from tb11 where
url = "www.thaiall.com/article/spam.htm" or
url = "www.thaiall.com/actress/ae.htm"
order by url;
SELECT url FROM `tot` where mid(url,1,15) = "www.thaiabc.com"
SELECT * FROM tot WHERE mid( url, 6, 1 ) = "+" OR mid( url, 3, 1 ) = "/" ORDER BY `dtime` DESC LIMIT 0 , 30