Test, validate and match regular expressions
This case-insensitive regex matches any string containing the exact phrase "LONG BLOB". It effectively searches through multiline text by matching any combination of whitespace and non-whitespace characters before the phrase. This is useful for scanning SQL dumps or configuration files for specific database data types.