[Resolved] Where in Select Statement

ok I'm trying to figure this out.

If I do the following in phpmyadmin\sql

SELECT *
FROM `destinations`
WHERE `id` = 1 LIMIT 0 , 30

It works and shows the row with the id of 1..

So then when I try this:

 SELECT *
FROM `destinations`
WHERE `Destination_ID` = Domestic
LIMIT 0 , 30

It doesn't work and it states that Domestic is unknown..

And I do have 2 rows that have Domestic under Destination_ID.

What am I missing here to make the connection..

thanks for your help
Scott

Try this:

 
SELECT *
FROM `destinations`
WHERE `Destination_ID` = 'Domestic'
LIMIT 0 , 30

You need quotes around the text you are looking for!

Also its better to not select * but put the field names you need to select - its faster..

Thanks for that, I didnt know what I was missing..

On the select *
what could the syntax be then for what I'm trying out here..

SELECT  Destination_ID FROM 'destinations' WHERE ??

Just learning DB querying..

No problems,

Select * returns all the fields - but its not as efficent as naming the names themselves!

so use something like and only ask to select what you need:

SELECT destinations, Destination_ID
FROM destinations
WHERE Destination_ID = 'Domestic'
LIMIT 0 , 30

Good luck!