Physics Education Literature -- SQL Search

	Physics Education Literature Home \| Simple Search \| Advanced Search \| Add Record \| CSA Import
	Search the database by use of a SQL query:	Login

Mon, 12 May 2008 12:30:50 -0400

SQL Query:		SELECT author, title, year, publication, volume, pages FROM refs WHERE year > 2001 ORDER BY year DESC, author
Output Options:		Display Links Show records per page
		Display SQL query


Examples:		`SELECT author, title, year, publication FROM refs WHERE publication = "Polar Biology" AND author RLIKE "Legendre\|Ambrose" ORDER BY year DESC, author`
		`SELECT serial, author, title, year, publication, volume FROM refs ORDER BY serial DESC LIMIT 10`
Help:		The MySQL online manual has a tutorial introduction on using MySQL and provides a detailed description of the `SELECT` syntax.