Regular Expression - SQL

[Saurabh Jain]

Regular Expression - SQL
===================

• ◼A Regular Expression(RegEx) is used to match patterns with various sequences of characters.
• ◼A RegEx can be a combination of different data types such as integer, special characters, Strings, images, etc.
• ◼These patterns are used in String searching algorithms in order to perform find or find and replace operations on Strings, or for validating the input.
• ◼RegEx are not case sensitive

🔷Syntax for using SQL Regex:
=======================
SELECT
<column_name>...
from <table_name>
WHERE <col_name***>
REGEXP 'my_pattern';

<col_name***> : column on which the regular expression needs to be applied