SQL Comment Regex Pattern

Live Regex Tester

Pattern Breakdown

Code Examples

const regex = /--.*$|\/\*[\s\S]*?\*\//gm;
const test = "-- This is a comment";
console.log(regex.test(test)); // true

// Extract matches
const matches = test.match(regex);
console.log(matches);

import re

pattern = r'--.*$|\/\*[\s\S]*?\*\/'
test = "-- This is a comment"
match = re.findall(pattern, test)
print(match)  # Found!

package main

import (
    "fmt"
    "regexp"
)

func main() {
    re := regexp.MustCompile(`--.*$|\/\*[\s\S]*?\*\/`)
    fmt.Println(re.MatchString("-- This is a comment")) // true
}

Common Use Cases

Match Examples

About the SQL Comment Regex

Matches both single-line (--) and multi-line (/* */) SQL comments for stripping or extracting documentation.

Regular expressions (regex) are powerful pattern matching tools used across virtually all programming languages. The sql comment pattern is classified as intermediate difficulty in the data formats category. This pattern is specifically designed for SQL.

When using this regex, always consider edge cases and test thoroughly with real-world data. Use the interactive tester above to validate the pattern against your specific inputs before deploying to production.

More Data Formats Patterns