Difference between revisions of "Gleis Week 6"
From LMU BioDB 2013
| Line 17: | Line 17: | ||
#*"The 2000 Year Old Man" | #*"The 2000 Year Old Man" | ||
#*"Teenage Mutant Ninja Turtles (1980s)" | #*"Teenage Mutant Ninja Turtles (1980s)" | ||
| + | #select title from movie where title ~ '''' | ||
| + | #*"Paula Abdul's Get Up & Dance" | ||
| + | #*"Class of Nuke 'Em High 2" | ||
| + | #*"By Dawn's Early Light" | ||
| + | #*"Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo" | ||
| + | #*"Sesame Street: Elmo's World: The Street We Live On" | ||
| + | #*"Something's Gotta Give" | ||
| + | #*"ABC Primetime: Mel Gibson's The Passion of the Christ" | ||
| + | #*"Ashtanga Yoga: Beginner's Practice with Nicki Doane" | ||
| + | #*"Zatoichi's Conspiracy" | ||
| + | #*"We're Not Married" | ||
Revision as of 19:20, 3 October 2013
Movies from Text File to Tables
- select * from movie where year < 1915
- "D.W. Griffith: Years of Discovery 1909-1913" "Lumiere Brothers' First Films"
- Tillie's Punctured Romance" "Cabiria"
- select title from movie where title ~ '[0123456789][0123456789][0123456789][0123456789]' and year >= 1980 and year < 1990
- "Cherry 2000"
- "2010: The Year We Make Contact"
- "1984"
- "Cold Summer of 1953"
- "Butthole Surfers: Blind Eye See All: Live 1985"
- "Gundam 0080: War in the Pocket"
- "Transylvania 6-5000"
- "Hong Kong 1941"
- "1969"
- "Mystery Science Theater 3000: The Crawling Hand"
- "Eric Clapton & Friends: Live 1986"
- "The 2000 Year Old Man"
- "Teenage Mutant Ninja Turtles (1980s)"
- select title from movie where title ~ '
- "Paula Abdul's Get Up & Dance"
- "Class of Nuke 'Em High 2"
- "By Dawn's Early Light"
- "Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo"
- "Sesame Street: Elmo's World: The Street We Live On"
- "Something's Gotta Give"
- "ABC Primetime: Mel Gibson's The Passion of the Christ"
- "Ashtanga Yoga: Beginner's Practice with Nicki Doane"
- "Zatoichi's Conspiracy"
- "We're Not Married"
