Can you use regular expressions in sql

Kalyan Vasanth Kalyan Vasanth 63 1 1 silver badge 6 6 bronze badges. Match input, regex. Fiach Reid Fiach Reid 4, 1 1 gold badge 26 26 silver badges 31 31 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete?

Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Linked See more linked questions. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.

A regular expression is a sequence of characters used to match a pattern to a string. You can use it for searching text and validating input. A regular expression must be enclosed within single quotes. Doing so ensures that the entire expression is interpreted by the SQL function. View all Courses. All rights reserved. Courses Pricing. How to create regular expressions in SQL. Live Project Expand child menu Expand. AI Expand child menu Expand.

Toggle Menu Close. Search for: Search. For Example, Angels and Demons. The question? For Example, comedy , romantic comedy. The dot. For Example, ,, etc. The third character should be either I or S. The fourth and fifth characters will be SE — this combination is static. The sixth character will be a space. Visited 3, times, 11 visits today. Subscribe to our digest to get SQL Server industry insides! He has expertise in database design, performance tuning, backup and recovery, HA and DR setup, database migrations and upgrades.

Clark Hunter says:. August 13, at Write for us CodingSight is open for new authors and partnership proposals. Facebook Twitter LinkedIn.