Account for placeholder text in comments and quoted strings in SQL

Description

-- Run the SQL??
select *
/* This is the wrong table? */
from table
where col = 'do you like spam? I sure do.'
  and col2 = ?

-- foo :param bar
select *
/* foo :param bar */
from table
where col = 'foo :param bar'
  and col2 = :param

Show:

Fixed

Pinned fields

Click on the next to a field label to start pinning.

Created December 28, 2024 at 8:11 PM

Updated January 1, 2025 at 6:56 PM

Resolved January 1, 2025 at 6:56 PM