Question 185Asked in DSSSB TGT Computer Science, 7 Feb 2024, Shift 2 (12:30 PM)

Which of the following operator of SQL is used in WHERE clause for match a character

Which of the following operator of SQL is used in WHERE clause for match a character pattern in database?
  1. ALIKE
  2. BIN
  3. CIS NULL
  4. DOR
Show answerHide answer

Correct answer: (A) LIKE

Explanation

LIKE is used in WHERE for pattern matching with wildcards % and _, e.g. WHERE name LIKE 'A%'.

From DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM)

This is question 185 of DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.