Which of the following criterion will search for songs that contain the word "love" somewhere in the middle of the song title?
A)Contains "love"
B)Like *"love"*
C)Like "* love"
D)Like "* love *"

Question

Quizplus · Accepted Answer

The correct choice is D) Like "* love *". This SQL pattern matching criterion specifies that "love" must appear somewhere in the middle of the string, with any number of characters before and after it, which is exactly what is needed to find songs with "love" in the middle of the title.

Which of the Following Criterion Will Search for Songs That