View source for Yurttas/PL/DBL/postgres/F/01/Movies/q10.sql

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

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: writer.

You can view and copy the source of this page.

<syntaxhighlight lang="sql" line start="1" enclose="div">/*
REM
REM q10.sql 
REM
REM Search and find all movies with a 
REM possesive ('s) in their titles. 
REM
*/

SELECT current_schema();
SET search_path to "movies";

SELECT title 
FROM Movie 
WHERE title LIKE '%''s%'; 
</syntaxhighlight>

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

Retrieved from "http://wiki.zcubes.com/Yurttas/PL/DBL/postgres/F/01/Movies/q10.sql"