Fixed Condition With PreparedStatament - Use Placeholder?

[James Gordon]

Hi,

Let's say I have a query (PreparedStatement) with some conditions and one of it
is a fixed condition. Below is to illustrate:

SELECT * FROM mytable WHERE field1 = ? AND field2 = ? AND field3 = 0

Take note of field3 which has a fixed condition.
Is it a good idea to make it a placeholder(?) as well?

It's going to achieve the same thing but I'm just looking
for good practice.

Please comment.


Thanks in advance.

[Paul Clapham]

Not really, no.

Edit: Why do I say that? Because it's not generally a good idea to write code that isn't necessary. Even there's only one more line of code for you to write, it's still a line of code which you might get wrong, and which has to be tested.

[Sagar Rohankar]

If its really a fixed value, then hard coding is more secure and trouble free than putting one more statement for the same, which finally, yields the same result.