View Search Tips
This search uses Boolean fulltext searching in MySQL. It works essentially the same way that Google does, with a few slight twists. For easily communicated instructions, a Boolean “AND” can be queried by placing the term “AND” between terms. A Boolean "OR" query can be structured similarly: with “OR” placed between terms.
The form accepts up to six unique terms using these systems. For more complex queries, MySQL's Boolean modifiers can be used. See the article Working with Boolean Queries in MySQL/PHP for an explanation of these modifiers.
The default search is a word search: each word of your query is searched independently, although if any exact match exists that will be sorted to the top (if you're using the default sort by relevancy). By placing quotes around your search phrase you can search the exact phrase (like Google).
Some data may be more easily interrogated using a spreadsheet or a relational database structure which can be developed using the Excel file. To download the entire database as an Excel file follow this link: click here.
To download a strategic summary of the database click here.
Hide Search Tips
Simple Boolean Search Version 2.6 by Joe Dolson Accessible Web Design