Enter text in the fields below and tell us to the right of each whether it's a credit (studio, model, actor, etc.), or a theme. You have to spell all of these the way we have them in our database (case is unimportant), so before you enter them, find out the ones you want and see how we spell them. We'll get a list of movies that share all of the values that you enter and show them to you. You can also enter a range of production years to restrict the list to titles produced in those years. Or leave the start and end years blank to get all titles regardless of when they were produced. Provide a start year and leave the end year blank to get all titles produced that year or later, and leave the start year blank and enter an end year to get all of those titles produced before or during that year. To do a "fuzzy" search, use "%" in your text. If you want to find all Falcon and Falcon International, enter "falcon%". If you want to find just Falcon, enter "falcon". If you want to find Falcon, Falcon International, and Johnny Falconberg, enter "%falcon%". The percent sign can appear anywhere in the text and will match any character(s).

This search uses Advanced Regular Expressions as defined by PostgreSQL. This is not for the faint of heart and is very technical. We actually added this functionality to make it possible to find all actors whose last name starts with 'R' (just an example). To find all actors whose last name starts with an 'R', enter the search string '.*\\sR.*'. The \\s matches a space. The .* matches one or more characters. So this will find anyone whose name has some number of characters followed by a space followed by an 'R' followed by any number of characters. This search is case sensitive.