Yurttas/PL/DBL/postgres/F/01/Movies/q10.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM q10.sql 
 4REM
 5REM Search and find all movies with a 
 6REM possesive ('s) in their titles. 
 7REM
 8*/
 9
10SELECT current_schema();
11SET search_path to "movies";
12
13SELECT title 
14FROM Movie 
15WHERE title LIKE '%''s%';