alert http $EXTERNAL_NET any -> $HOME_NET any (
msg:"ET WEB_SERVER Possible SQL Injection SELECT FROM in HTTP Request Body";
flow:established,to_server;
http.request_body;
content:"SELECT"; fast_pattern; nocase;
content:"FROM"; nocase; within:100;
pcre:"/SELECT.+FROM.+(?:\x3b|\x253b)/i";
reference:url,owasp.org/www-community/attacks/SQL_Injection;
classtype:attempted-admin;
sid:2053459; rev:2;
metadata:affected_product Web_Server_Applications, attack_target Web_Server, created_at 2024_06_11, deployment Perimeter, deployment SSLDecrypt, performance_impact Moderate, confidence Medium, signature_severity Major, tag SQL_Injection, updated_at 2024_07_25, reviewed_at 2024_10_04, mitre_tactic_id TA0001, mitre_tactic_name Initial_Access, mitre_technique_id T1190, mitre_technique_name Exploit_Public_Facing_Application;
target:dest_ip;
)