Which of the following MySQL query will display all the NAME from the table…

Which of the following MySQL query will display all the NAME from the table STUDENT, which are having exactly five characters and starting with the alphabet ‘A’?

  1. A.

    SELECT NAME FROM STUDENT

    WHERE NAME LIKE 'A____';

  2. B.

    SELECT NAME FROM STUDENT

    WHERE NAME = 'A____';

  3. C.

    SELECT NAME FROM STUDENT

    WHERE NAME = 'A%%%%%';

  4. D.

    SELECT NAME FROM STUDENT

    WHERE NAME LIKE 'A%%%%%';

Attempted by 2726 students.

Sign up free to check your answer

Sign up free

Explore the full course: Bpsc

Loading lesson…