ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

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.
Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
Ishwar Kokkili
Ishwar Kokkili 5 years ago
%0 - feature ends with 0
0% - 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