I am learning to query the MySQL database
artimus_article.  My database is a storage of articles
with name of the creator, title of the article, the
category in which the article is classifies, ....,
etc.

I try to search articles by the name of the creator
within the "computer science" category.  Are there
mistakes in my prepared statement shown below?

SELECT * FROM artimus_article WHERE creator LIKE (?)
AND category=computer science ORDER BY creator,title;

Should I put computer science in a pair of double
quote or a pair of single quote?

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to