Querying a Database

I have finished putting in the query and it came up with the correct name i put in which is text. when i put in the second name in the 'or' row it came up with both the first and second names i queried.

when you put a query in you can put an * in which represents a wildcard which means that anything can go in it's place. for example, it you are looking up mary and you type m* it means look up any names starting with m. if you put an * before a letter it means that it has to end in that letter and also if you put a letter between two * then it has to that letter somewhere in the name.

when you are querying you can put it in the 'and' row which means it will look up both of what you type in. for example, if you type in tom and frank then it will find both tom and frank. if you type it in the 'or' row it will find both tom and frank or only one.