Leetcode Problem 1527. Patients With a Condition

1527. Patients With a Condition

Leetcode Solutions

Select the patient_id, patient_name, and conditions columns from the Patients table.
Use the WHERE clause to filter the results based on the conditions column.
Within the WHERE clause, use the LIKE operator with two patterns: 'DIAB1%' and '% DIAB1%'.
Use the OR logical operator to combine the two LIKE conditions, ensuring that either condition will include the patient in the results.
The final result will include all patients whose conditions column contains a Type I Diabetes code.

erDiagram
    Patients {
        int patient_id
        varchar patient_name
        varchar conditions
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen