to_char(gmt_created, ‘mmdd') = '0101′

gmt_created between to_date(“20090101″, “yyyymmdd”) and to_date(“20090102″, “yyyymmdd”)

member_id like ‘%alibab%'

select subject from offer where member_id=234

select subject, gmt_created from offer where member_id=234

count(id) === count(1) where id is not null

select count(*) from offer where member_id=234 limit 1

select count(*) from offer where member_id=234

select *
from
(
select t.*, rownum AS rn
from
(select * from blog.blog_article
where domain_id=1
and draft=0
order by domain_id, draft, gmt_created desc) t
where rownum >= 2
) a
where a.rn <= 3

select blog_article.*
from
(
select rid, rownum as rn
from
(
select rowid as id from blog.blog_article
where domain_id=1
and draft=0
order by domain_id, draft, gmt_created desc
) t
where rownum >= 2
) a, blog_article
where a.rn >= 3
and a.rid = blog_article.rowid

ORDER BY a ASC, b DESC, c DESC /* mixed sort direction */

WHERE g = const ORDER BY b, c /* a prefix is missing */

WHERE a = const ORDER BY c /* b is missing */

WHERE a = const ORDER BY a, d /* d is not part of index */

select * from title where kind_id=1 order by rand() limit 1;
create index k on title(kind_id);

select round(rand() * count(*)) from title where kind_id=1;
select * from title where kind_id=1 limit 1 offset $random;
create index k on title(kind_id);

select round(rand() * count(*)) from title where kind_id=1;
select * from title where kind_id = and id > $random limit 1;

CREATE TABLE `user` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`account` char(11) NOT NULL COMMENT ”,
`email` varchar(128),
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`account`)
) ENGINE=InnoDB CHARSET=utf8;
mysql> explain select * from user where account=123 \G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: user
type: ALL
possible_keys: username
key: NULL
key_len: NULL
ref: NULL
rows: 2
Extra: Using where
1 row in set (0.00 sec)