This is a dedicated watch page for a single video.
A company stores its user information in a MySQL database table called user . The name column has the users' names stored in firstname lastname format. Due to legacy reasons, a few users have the names stored in lastname firstname format. A data engineer has been tasked with developing a query that returns all records where the name column has values starting with John or Doe , on a case-insensitive basis. Which of the following queries represents the correct solution?