Jump to content
Business Intelligence & Analytics for Digital Transformation

Open Club  ·  189 members

SQL

Regular Expression - SQL


Saurabh Jain
 Share

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:
=======================
SELECT
<column_name>...
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

 Share

×
×
  • Create New...