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:
Gabriel Fróes
|
Source |
|
Your Rating |
|
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.