4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Select from
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
Kdawg
Senior WebHelper
Senior WebHelper


Joined: 21 Apr 2003
Posts: 153

PostPosted: Thu May 22, 2003 1:14 am (14 years, 5 months ago) Reply with QuoteBack to Top

I cant figure this out, I have a table with the field "Location" in it. Location is varchar(20) and I store the location name in it. Theres going to be lots of different states in it, I want to be able to go SELECT * FROM gamertags WHERE Location = Ohio, but when I do it doesnt work. How can I make this work?
OfflineView User's ProfileFind all posts by KdawgSend Personal Message
verto
Senior WebHelper
Senior WebHelper


Joined: 14 Jan 2002
Posts: 220
Location: Cambridge MA USA

PostPosted: Thu May 22, 2003 3:38 am (14 years, 5 months ago) Reply with QuoteBack to Top

From SQL you've posted, Kdawg, I suspect you may just be missing the quote marks, as in:
Code:
SELECT * FROM Destruction
WHERE City='Baghdad'

You should probably keep in mind that SQL uses single quotes around text values tho' I hear most DBMSs will also take double quotes. Also, numerics don't get quotes.

Neutral

________________________________
>>>>>>>>>>>>>
GENERAL DISCLAIMER:This disclaimer may be void where null in all cases unless explicitly not unprohibited or (p)re-exclusively assigned by sufficient presedimentation on behalf of every non-interested party to wit (or so it was said).
:::
.: :. . : :....: :.: .: :. verto .: :. . : :....: :.: .: :.
OfflineView User's ProfileFind all posts by vertoSend Personal Message
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.062754 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme