MySQL Tutorial 1: Overview, Tables, Queries

Now, just to (a) do something I've always wanted to try, and (b) show a more complex query, here's one that uses the above geographical information to search within a rectangular region: mysql> SELECT `city`,`state`,count(*) as `total` FROM `zipcodes` WHE

www.arachnoid.com