whether to use 1=1 or not?

[PHPycho]

I would like to know if there is any performance problem while using 1=1 condition in sql query.
for example:

SELECT
	*
FROM
	`table`
WHERE
	1=1
	AND `field` = value

Such condition becomes handy in conditional search. For example

if(isset($name)){
$sql_where .= " AND name='".$name."'";
} 

....so on

And using in query:

SELECT
	*
FROM
	`table`
WHERE
	1=1
	{$sql_where}

Yours opinion please!!

[r937]

WHERE 1=1 is a valuable coding technique that has no performance penalty

of course, you only need it in queries which require that the WHERE clause be built on-the-fly dynamically at execution time

[PHPycho]

WHERE 1=1 is a valuable coding technique that has no performance penalty

of course, you only need it in queries which require that the WHERE clause be built on-the-fly dynamically at execution time

Thanks rudy.
Actually i used to perform in this way. But my friend argued that using such techniques of 1=1 makes query slow, so i thought to put in discussion.

[felgall]

As a static comparison that always evaluates to true it would be stripped out before the optimizer starts processing the rest of the command.