-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 11:54 PM
To: Marcus Ouimet
Subject: Re: Select Letter/Number 


Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:

database,sql,query

If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. You have written the following:


I am wondering if it is possible to use the select command to bring up a
field that has any letter or number in it and not the blank fields. Ie.

SELECT products_id,products_name,products_info from products where 1 and
products_info like "%"

That brings up everything including blank fields. I just need all the
fields with any information in them (letters, numbers, etc.), not the
blank ones. Any help would be appreciated. Thanks in advance.




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to