Constants in SQL SELECT

[Dinky]

Is it possible to use constants in SQL statements?

define(COUNTRY_ID,'1');

e.g.: SELECT * FROM country WHERE id=COUNTRY_ID

I am using PHP5 and MySQL

[bradgrafelman]

Of course, you can use constants in any string:

$query = 'SELECT * FROM country WHERE id=' . COUNTRY_ID;