79718124

Date: 2025-07-29 05:00:36
Score: 0.5
Natty:
Report link

The documentation says this:

Bind a named statement parameter for ":x" placeholder resolution, with each "x" name matching a ":x" placeholder in the SQL statement.

Although you could infer otherwise, testing suggests that it indeed binds multiple placeholders that share a name.

The query in the sample situation would end up like this:

SELECT * FROM table WHERE colA = 'bar' OR colB = 'bar'

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Lucca Bibar