mysql> SELECT * FROM example_table ORDER BY id ;
+----+---------------------------------------------------------------------------------+---------------------------------------------------+
| id | somefield | otherfield |
+----+---------------------------------------------------------------------------------+---------------------------------------------------+
| 1 | there is a single space between each and every word in this entry in this field | and each one of these words is also single-spaced |
| 2 | there are five words here | here are four words |
| 3 | three words here | two words |
+----+---------------------------------------------------------------------------------+---------------------------------------------------+
3 rows in set (0.01 sec)
mysql>
mysql>
SELECT * FROM USPS_abbr ORDER BY state ;
+------+----------------+
| abbr | state |
+------+----------------+
| AL | Alabama |
| AK | Alaska |
| AZ | Arizona |
| AR | Arkansas |
| CA | California |
| CO | Colorado |
| CT | Connecticut |
| DE | Delaware |
| FL | Florida |
| GA | Georgia |
| HI | Hawaii |
| ID | Idaho |
| IL | Illinois |
| IN | Indiana |
| IA | Iowa |
| KS | Kansas |
| KY | Kentucky |
| LA | Louisiana |
| ME | Maine |
| MD | Maryland |
| MA | Massachusetts |
| MI | Michigan |
| MN | Minnesota |
| MS | Mississippi |
| MO | Missouri |
| MT | Montana |
| NE | Nebraska |
| NV | Nevada |
| NH | New Hampshire |
| NJ | New Jersey |
| NM | New Mexico |
| NY | New York |
| NC | North Carolina |
| ND | North Dakota |
| OH | Ohio |
| OK | Oklahoma |
| OR | Oregon |
| PA | Pennsylvania |
| RI | Rhode Island |
| SC | South Carolina |
| SD | South Dakota |
| TN | Tennessee |
| TX | Texas |
| UT | Utah |
| VT | Vermont |
| VA | Virginia |
| WA | Washington |
| WV | West Virginia |
| WI | Wisconsin |
| WY | Wyoming |
+------+----------------+
50 rows in set (0.02 sec)
mysql>
Related Stories
Greetings Soylentils! And welcome to SoylentNews!
We are here to deliver the best community-sourced news, catered for all manner of nerd! Because this is a grassroots based platform, the content feeds are powered by readers like you. Our main objective is to highlight news stories on the web that are of importance to everyone, but especially nerds. In addition, SoylentNews will strive to go beyond simple news-aggregation, with some core principles:
- Providing a soapbox for experts to discuss their profession and solicit questions from a curious audience.
- Allowing the community to comment, without any mandatory registration.
- Staying mindful of the community's needs and wants while avoiding changes to satisfy an overarching corporate agenda.
We want to make this your source for news about technology, art, science and politics. We are the new kid on the block and are adapting quickly to satisfy our community's needs, as we look forward to exceeding your expectations and pushing boundaries like never before. Lastly, there will be no changes in format without a general consensus from the community. Thank you for stopping by and enjoy the ride!
~Dopefish