Publicacions CVC -- SQL Search

	Publicacions CVC Home \| Show All \| Simple Search \| Advanced Search \| Add Record \| Import	Login Quick Search: Field: contains: ...
	Search the database by use of a SQL query:

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


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.