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]