Regular expressions·a SQL line comment

a SQL line comment

Matches a SQL line comment. It finds the match anywhere inside the text. There are no capture groups.

Pattern
/--[^\n]*/
Match scope
anywhere inside the text
Capture groups
0
What it catches in the first example
-- 주석

Try it yourself

Type any text and the parts this expression catches are highlighted. It runs in your browser and is never sent anywhere.

SELECT 1 -- 주석 -- 줄 전체

2 matches

Examples that match

  • SELECT 1 -- 주석
  • -- 줄 전체

Examples that do not match

  • SELECT 1
  • /* block */

Other expressions in this group

How to read this

  • With ^ and $ around it, the whole string must match; without them the match can sit anywhere. Always anchor an expression you use for validation.
  • Round brackets ( ) capture what they wrap. When you only need grouping, write (?: ) so the numbering of later groups does not shift.
  • Every expression here is checked against its examples. Even so, "looks like an email" and "is a real inbox" remain different questions.
  • Nested open-ended repeats such as (a+)+ can blow up on certain inputs. Look for that shape before pasting someone else’s expression into your code.

Frequently asked questions

Q. What is the regex for a SQL line comment?

--[^\n]*.

Q. Which strings match?

Text like SELECT 1 -- 주석 matches; text like SELECT 1 does not.

Q. Does the whole string have to match?

No. It finds the part anywhere inside the text. Add ^ and $ around it if you want a whole-string check.

Q. How do I use what it caught?

There are no capture groups, so only the whole match (match[0]) comes back. Wrap the part you need in brackets to capture it.