1527. Patients With a Condition | SQL | LeetCode |

Опубликовано: 21 Май 2025
на канале: SheCodes

133

🔍 SQL Tutorial: Pattern Matching with Wildcards & LOCATE Function 🔍

In this video, we dive into SQL's pattern matching using the % wildcard and compare it with the powerful LOCATE() function. You'll learn how to search for specific conditions in a column, such as finding patient records with the condition 'DIAB1' in a medical database.

Whether you're using LIKE with % to match patterns or LOCATE() for more direct string searching, both methods are incredibly useful in SQL queries.

📌 Topics Covered:

What is % in SQL and how to use it with the LIKE operator for flexible pattern matching
Using the LOCATE() function to find the exact position of a substring within a string
Example queries to filter rows based on specific conditions
🎯 Example Queries included in the video:

SQL pattern matching using LIKE with %
Using LOCATE() to find substring positions
Hit the Subscribe button for more SQL tutorials and query tips!

#SQL #Database #PatternMatching #LOCATE #LIKEOperator #DataQuery #SQLQuery #SheCodes"

SQL Query Using LOCATE():
SELECT *
FROM Patients
WHERE LOCATE('DIAB1', conditions) = 1
OR LOCATE(' DIAB1', conditions) != 0;