SQL select statements

SELECT name, count
 from `counters`

rows=23

Crude and Dirty Way
c 3076
PERL Way
c3076
Crude and Dirty Way
  3112
PERL Way
 3112
Crude and Dirty Way
frog 294
PERL Way
frog294
Crude and Dirty Way
dog 1092
PERL Way
dog1092
Crude and Dirty Way
cat 535
PERL Way
cat535
Crude and Dirty Way
test 34
PERL Way
test34
Crude and Dirty Way
papersplease 99976
PERL Way
papersplease99976
Crude and Dirty Way
crazyatheist 86456
PERL Way
crazyatheist86456
Crude and Dirty Way
otherkrap 4846
PERL Way
otherkrap4846
Crude and Dirty Way
dogmeat 0
PERL Way
dogmeat0
Crude and Dirty Way
ice_cream_anarchist 537
PERL Way
ice_cream_anarchist537
Crude and Dirty Way
kevin_walsh 1583
PERL Way
kevin_walsh1583
Crude and Dirty Way
badtempecop 7071
PERL Way
badtempecop7071
Crude and Dirty Way
jon_doron 5698
PERL Way
jon_doron5698
Crude and Dirty Way
marc_hoy 7724
PERL Way
marc_hoy7724
Crude and Dirty Way
xxxxx 0
PERL Way
xxxxx0
Crude and Dirty Way
news 28731
PERL Way
news28731
Crude and Dirty Way
messy_yard_criminals 10946
PERL Way
messy_yard_criminals10946
Crude and Dirty Way
x33 178
PERL Way
x33178
Crude and Dirty Way
mikes_java_script 243
PERL Way
mikes_java_script243
Crude and Dirty Way
me 1278
PERL Way
me1278
Crude and Dirty Way
homeless 21437
PERL Way
homeless21437
Crude and Dirty Way
other_stuff 63932
PERL Way
other_stuff63932
SELECT name, count
 from `counters`
 order by name, count
rows=23

Crude and Dirty Way
  3112
PERL Way
 3112
Crude and Dirty Way
badtempecop 7071
PERL Way
badtempecop7071
Crude and Dirty Way
c 3076
PERL Way
c3076
Crude and Dirty Way
cat 535
PERL Way
cat535
Crude and Dirty Way
crazyatheist 86456
PERL Way
crazyatheist86456
Crude and Dirty Way
dog 1092
PERL Way
dog1092
Crude and Dirty Way
dogmeat 0
PERL Way
dogmeat0
Crude and Dirty Way
frog 294
PERL Way
frog294
Crude and Dirty Way
homeless 21437
PERL Way
homeless21437
Crude and Dirty Way
ice_cream_anarchist 537
PERL Way
ice_cream_anarchist537
Crude and Dirty Way
jon_doron 5698
PERL Way
jon_doron5698
Crude and Dirty Way
kevin_walsh 1583
PERL Way
kevin_walsh1583
Crude and Dirty Way
marc_hoy 7724
PERL Way
marc_hoy7724
Crude and Dirty Way
me 1278
PERL Way
me1278
Crude and Dirty Way
messy_yard_criminals 10946
PERL Way
messy_yard_criminals10946
Crude and Dirty Way
mikes_java_script 243
PERL Way
mikes_java_script243
Crude and Dirty Way
news 28731
PERL Way
news28731
Crude and Dirty Way
otherkrap 4846
PERL Way
otherkrap4846
Crude and Dirty Way
other_stuff 63932
PERL Way
other_stuff63932
Crude and Dirty Way
papersplease 99976
PERL Way
papersplease99976
Crude and Dirty Way
test 34
PERL Way
test34
Crude and Dirty Way
x33 178
PERL Way
x33178
Crude and Dirty Way
xxxxx 0
PERL Way
xxxxx0
SELECT name, count
 from `counters`
 order by count,name
rows=23

Crude and Dirty Way
dogmeat 0
PERL Way
dogmeat0
Crude and Dirty Way
xxxxx 0
PERL Way
xxxxx0
Crude and Dirty Way
test 34
PERL Way
test34
Crude and Dirty Way
x33 178
PERL Way
x33178
Crude and Dirty Way
mikes_java_script 243
PERL Way
mikes_java_script243
Crude and Dirty Way
frog 294
PERL Way
frog294
Crude and Dirty Way
cat 535
PERL Way
cat535
Crude and Dirty Way
ice_cream_anarchist 537
PERL Way
ice_cream_anarchist537
Crude and Dirty Way
dog 1092
PERL Way
dog1092
Crude and Dirty Way
me 1278
PERL Way
me1278
Crude and Dirty Way
kevin_walsh 1583
PERL Way
kevin_walsh1583
Crude and Dirty Way
c 3076
PERL Way
c3076
Crude and Dirty Way
  3112
PERL Way
 3112
Crude and Dirty Way
otherkrap 4846
PERL Way
otherkrap4846
Crude and Dirty Way
jon_doron 5698
PERL Way
jon_doron5698
Crude and Dirty Way
badtempecop 7071
PERL Way
badtempecop7071
Crude and Dirty Way
marc_hoy 7724
PERL Way
marc_hoy7724
Crude and Dirty Way
messy_yard_criminals 10946
PERL Way
messy_yard_criminals10946
Crude and Dirty Way
homeless 21437
PERL Way
homeless21437
Crude and Dirty Way
news 28731
PERL Way
news28731
Crude and Dirty Way
other_stuff 63932
PERL Way
other_stuff63932
Crude and Dirty Way
crazyatheist 86456
PERL Way
crazyatheist86456
Crude and Dirty Way
papersplease 99976
PERL Way
papersplease99976
SELECT name, count
 from `counters`
 where name like 'c%'

rows=3

Crude and Dirty Way
c 3076
PERL Way
c3076
Crude and Dirty Way
cat 535
PERL Way
cat535
Crude and Dirty Way
crazyatheist 86456
PERL Way
crazyatheist86456
SELECT name, count
 from `counters`
 where name like 'c%'
 order by name, count
rows=3

Crude and Dirty Way
c 3076
PERL Way
c3076
Crude and Dirty Way
cat 535
PERL Way
cat535
Crude and Dirty Way
crazyatheist 86456
PERL Way
crazyatheist86456
SELECT name, count
 from `counters`
 where name like 'c%'
 order by count,name
rows=3

Crude and Dirty Way
cat 535
PERL Way
cat535
Crude and Dirty Way
c 3076
PERL Way
c3076
Crude and Dirty Way
crazyatheist 86456
PERL Way
crazyatheist86456
SELECT name, count
 from `counters`
 where name='c'

rows=1

Crude and Dirty Way
c 3076
PERL Way
c3076
SELECT name, count
 from `counters`
 where name='c'
 order by name, count
rows=1

Crude and Dirty Way
c 3076
PERL Way
c3076
SELECT name, count
 from `counters`
 where name='c'
 order by count,name
rows=1

Crude and Dirty Way
c 3076
PERL Way
c3076