Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does ":1", ":2" in SQL mean?

Tags:

sql

postgresql

I am looking at a sql statement that looks like this:

...
AND col2_.col_date >= :1
AND col2_.col_date <= :2
...

and I have no idea what :1 and :2 does??

Can someone enlighten me,

Thanks, :)

like image 463
Aion Avatar asked Dec 30 '25 08:12

Aion


1 Answers

They're placeholders in a parametrized query, waiting for the program to come along and supply the parameters.

like image 57
Ignacio Vazquez-Abrams Avatar answered Jan 02 '26 01:01

Ignacio Vazquez-Abrams



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!