newbie needs help with mysql query from a form submission

Hi guys. I have a simple form which has countries to choose from. Once a
country is chosen I need to do a select lookup. I can't find the correct
symbol for "all" countries in the lookup i.e can someone tell me what I
should palce instead of the ? in the following country to lookup all select
all countries :

SELECT * FROM database WHERE country=?

Thank you in advance,

Raj (newbie)

On 15 Mar, 13:34, raj <r...@nospam.com> wrote:
> Hi guys. I have a simple form which has countries to choose from. Once a
> country is chosen I need to do a select lookup. I can't find the correct
> symbol for "all" countries in the lookup i.e can someone tell me what I
> should palce instead of the ? in the following country to lookup all select
> all countries :
>
> SELECT * FROM database WHERE country=?
>
> Thank you in advance,
>
> Raj (newbie)


SELECT * FROM database

On 15 Mar, 14:07, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> SELECT * FROM my_table WHERE country LIKE '%';
>
> will pick all.
as will SELECT * FROM my_table