mysql query issue

Question

Let's assume I have the below table

mysql> desc countrylist;  
+---------+-------------+------+-----+---------+-------+  
| Field   | Type        | Null | Key | Default | Extra |  
+---------+-------------+------+-----+---------+-------+  
| country | varchar(32) | YES  |     | NULL    |       |  
+---------+-------------+------+-----+---------+-------+  
1 row in set (0.02 sec)  

While querying the table, I always want 'USA' in the result whether or not the value is there in the table, in addition to other countries in the table. How do I handle that?

TIA.

James.

Answer 1

You can use UNION:

SELECT country FROM countrylist
UNION
SELECT 'USA'