?
What is the meaning of LIKE '%0%0%'
Answer & Solution
Correct Answer:
Option
D
The SQL pattern LIKE '%0%0%' means that the "Feature" should have two 0's in it, at any position within the text. The '%' wildcard matches any sequence of characters, so the pattern can match any string as long as it contains two consecutive 0's, regardless of their position within the text. So, Option D is the correct choice for the meaning of this pattern.
Join the Discussion
Login to post a comment or share your explanation.
Login0% - feature begins with 0
%0% - feature has 0 at any position
%0%0% - the above things repeats 2 times. so, 2 0's at any position.
regards,
Ish