SELECT count(*) FROM film WHERE title LIKE "%Dummy%"
Count the number of films whose title contains the word 'Dummy'.
SELECT count ( * ) FROM film WHERE title LIKE `` % Dummy % ''
select count ( * ) from film where title like value
Count the number of films whose title contains the word 'Dummy ' .