RegExLib.com - The first Regular Expression Library on the Web!

Please support RegExLib Sponsors

Sponsors

Regular Expression Details

Title Test Find Pattern Title
Expression
(SELECT\s[\w\*\)\(\,\s]+\sFROM\s[\w]+)| (UPDATE\s[\w]+\sSET\s[\w\,\'\=]+)| (INSERT\sINTO\s[\d\w]+[\s\w\d\)\(\,]*\sVALUES\s\([\d\w\'\,\)]+)| (DELETE\sFROM\s[\d\w\'\=]+)
Description
This RE match the SQL Basics Queries (SELECT, UPDATE, INSERT and DELETE).
Matches
SELECT * FROM TABLE | UPDATE TABLE SET FIELD=VALUE WHERE ID_FIELD=VALUE_ID | DELETE FROM TABLE WHERE
Non-Matches
SELECT TABLE | UPDATE SET TABLE | INSERT INTO FIELD=VALUE TABLE
Author Rating: The rating for this expression. Gabriel Fróes
Source
Your Rating
Bad Good

Enter New Comment

Title

Name

Comment

Spammers suck - we apologize. Please enter the text shown below to enable your comment (not case sensitive - try as many times as you need to if the first ones are too hard):

Existing User Comments

Title: Mismatch
Name: Peter
Date: 3/27/2019 3:11:02 PM
Comment:
This regex matches "select Organizations from the Search drop-down list" too.


Copyright © 2001-2024, RegexAdvice.com | ASP.NET Tutorials