Where question 1

[jewel464g]

It's been quite some time since I've worked with SQL. This is what I need to do.

SELECT * FROM hotlines WHERE category=admin ORDER BY name

Select everything from the table hotlines with the field category contains the word admin, the order it by name. Something is obviously wrong with my syntax because I get errors when I put the WHERE part in. The following statment works fine. So it must be the WHERE part.

SELECT * FROM hotlines ORDER BY name


Thanks,
Jewel

http://www.scriptchick.com/

When faced with a decision, always ask, 'Which would be the most fun?'

 

[twcman]

I believe it would look something like this:

SELECT * FROM hotlines WHERE category='%admin%' ORDER BY name

Hope this helps...

Chris Scott
The Whole Computer Medical Systems

 

[sleipnir214]

Your query is not '...where the field "category" contains the word "admin"...'. Your query is '...where the field "category" is exactly the value of the field[/i] "admin"...'

If you're looking for a string value, put it in single quotes. Otherwise, you're comparing two fields. I'll bet you're getting a "column name does not exist" error.


Also, if you're looking for a field containing a string, you need to use something like the "like" operator:

SELECT * from hotlines where category like '%admin%' order by name

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[jewel464g]

SELECT * FROM hotlines WHERE category='admin' ORDER BY name

That did it.

Thanks.

http://www.scriptchick.com/

When faced with a decision, always ask, 'Which would be the most fun?'

 

[sleipnir214]

oops. Missed a "end underlining" tag in my post somewhere.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!