Easy Start:  To view your race results, in the "Where Statement" edit box, replace "John" with your first name and "Smith" with your last name (do not delete the quotation marks).  If you have changed your name and your results are listed under more than one name, choose from one of the built-in "Where Examples" to structure a query that will return results for both names.  You may select an "order by" statement to return the records by Date, Distance, etc. To save or print, and for more advanced options, see the Tutorial.


1. Double click an item to select.

2. A SELECT statement in its simplest form is SELECT * FROM RACERESULTS (select all fields from the RaceResults table).

3. To SELECT a subset of the fields, use SELECT field01, field02, field03, ..... FROM RACERESULTS.

4. The FROM RACERESULTS is always required.

5. To close this window, point anywhere outside the list box and click.



1. Double click an item to select.

2. A WHERE statement filters out unwanted records (important since the GWTC database contains approximately 250,000 records).

3. All parameters in a WHERE statement must be enclosed in matching single or double quotes (most common error).

4. Parentheses are used to assure AND/OR logic statements are correctly interpreted by MYSQL.

5. To close this window, point anywhere outside the list box and click.


1. Double click an item to select.

2. An ORDER BY statement is simply a list of VALID fieldnames separated by commas.

3. The purpose of the ORDER BY statement is to return a recordset in an order useful to the user.

4. The sort order is usually related to the WHERE statement but is not a requirement.

5. To close this window, point anywhere outside the list box and click.


RecIdPlaceAdjPlaceFirstNameLastNameAgeAgeGrpSexGunTimeSplitTimeChipTimeDistanceRaceRaceDate
56930JohnSmith019-24M00:13:43  2-mileTurkey Trot1976/11/25
297951070JohnSmith45 M00:24:18  5KPalace Saloon1998/04/18
155308970JohnSmith54 M00:26:18  5KFSU Parents Weekend2010/10/16
1953613840JohnSmith55 M00:26:25 00:26:045KPalace Saloon2012/04/14

You are viewing page 1 of 1
DataSet returned 4 records.