Jump to content
Business Intelligence & Analytics for Digital Transformation

Open Club  ·  189 members


Regular Expression - SQL

Saurabh Jain

Recommended Posts

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:
from <table_name>
WHERE <col_name***>
REGEXP 'my_pattern';

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


RegX SQL.jpg

Link to comment
Share on other sites


  • Create New...