Saurabh Jain Posted June 1, 2022 Share Posted June 1, 2022 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 Link to comment Share on other sites More sharing options...
Recommended Posts