COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Write the code for the following:Return all movies with the word love.
|
|
SELECT * FROM movies WHERE name LIKE %love%;
|
|
|
SELECT * FROM movies WHERE name LIKE ‘love’;
|
|
|
SELECT * FROM movies WHERE name LIKE %love;
|
|
|
SELECT * FROM movies WHERE name LIKE ‘%love%’;
|
Explanation:
There is 1 question to complete.