|
Author |
Message |
Kdawg
Senior WebHelper
Joined: 21 Apr 2003
Posts: 153
|
Posted:
Thu May 22, 2003 1:14 am (21 years, 1 month ago) |
|
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? |
|
|
|
|
verto
Senior WebHelper
Joined: 14 Jan 2002
Posts: 220
Location: Cambridge MA USA
|
Posted:
Thu May 22, 2003 3:38 am (21 years, 1 month ago) |
|
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.
|
________________________________ >>>>>>>>>>>>>
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 .: :. . : :....: :.: .: :. |
|
|
|
|
|
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.122379 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |