AR banner
Search for phrases in quotes eg "Alan Smith"
Back To Database

Runnymede Memorial Database: Effectively Searching The Database


Our databases employ MySQL to conduct Searches. This language does not allow certain words to be included in a Search. These are mainly programmer-centric words which are not commonly used in normal Searches. However, the words DOWN and ELSE are restricted and since these are sometimes used as names, they unfortunately cannot be Searched for. To overcome this limitation, we have changed all names Down into Downe, and all names Else into Elsee. Search for these changed names and you will find what you are looking for. In each case we have noted the change in the record itself.



Creative researchers are likely to find golden threads to research through an imaginative use of the power and flexibility now offered. The data has always been there of course, but seeing the connections has hitherto been problematical: sometimes the needle gets hidden in the haystack. This facility changes that.

Search on this database can be very powerful and useful. With a few simple techniques you will be able to extract information that you may not have found otherwise.

To get started, put a name in the Search box, for example Brown. (you don't have to capitalize names so brown will work the same way as Brown). The result is all the Browns in the database. From this first Search you can become familiar with the layout of the database which will enable you to conduct more complex Searches.

You can perform a Search for almost anything (3 characters or more) in any column. So now replace Brown with RCAF and now you see all those members of RCAF in the database. Now put Brown AND RCAF in the Search box. This will find all records of Browns who flew with the RCAF. (The AND is known as a Boolean operator, and tells our Search Engine you want to find entries that meet both specified criteria. (You don't have to capitalize AND incidentally: Brown and RCAF will work just as well, as will brown and rcaf). Other than in the case of capitalization, however, spelling IS important. A search on Browne will NOT find Brown for example.

You can have up to FIVE dependencies in a single search! For example Brown AND RCAF AND 489 Sqd would find all Browns who were Canadians in 489 Squadron.

A NOTE ON SEARCHES ON SQUADRON Because of technical limitations in the database software used at our hosting service you cannot search on less than 3 digits or 3 letters. You can't search for 1 for example, or B, or 72 or BA. In the case of squadrons we deal with this by adding Sqd to all squadrons. A Search on 1 Sqd will find all pilots flying in 1 Sqd.

If you are familiar with other Boolean operators, try those.

We would like to hear from researchers who find interesting connections through our Search Engine. Caring is Sharing! Perhaps you would like to contribute a story based on your research? We'll be happy to publish you.



View All Aircrew Remembered Databases Available For Search
© 2012 - 2016 Aircrew Remembered - All site material (except as noted elsewhere) is owned or managed by Aircrew Remembered
and should not be used without prior permission.