This example uses correlated subqueries to find any city that is a state name.
It shouldn't surprise us to find so many Washingtons, but Wyoming?
- California, KY
- California, MD
- California, MO
- California, PA
- Delaware, IA
- Delaware, OH
- Delaware, OK
- Florida, MO
- Florida, NY
- Florida, OH
- Indiana, PA
- Iowa, LA
- Kansas, AL
- Kansas, IL
- Kansas, OK
- Louisiana, MO
- Nevada, IA
- Nevada, MO
- Nevada, OH
- Nevada, TX
- New York, NY
- Ohio, IL
- Oklahoma, PA
- Oregon, IL
- Oregon, MO
- Oregon, OH
- Oregon, WI
- Tennessee, IL
- Vermont, IL
- Virginia, IL
- Virginia, MN
- Virginia, NE
- Washington, AR
- Washington, GA
- Washington, IA
- Washington, IL
- Washington, IN
- Washington, KS
- Washington, KY
- Washington, LA
- Washington, MO
- Washington, NC
- Washington, NE
- Washington, NJ
- Washington, OH
- Washington, OK
- Washington, PA
- Washington, UT
- Washington, VA
- Washington, WV
- Wyoming, DE
- Wyoming, IA
- Wyoming, IL
- Wyoming, MI
- Wyoming, MN
- Wyoming, NY
- Wyoming, OH
- Wyoming, PA
Also check out: CFM Zen Garden, and
jQuery Zen Garden.
Database: Phillip Senn
Design: Ryan Carroll