Jump to content

Archived

This topic is now archived and is closed to further replies.

centenial

SELECT FROM TABLE WHERE FIELDVALUE != ""

Recommended Posts

Hi,

Does anyone know the MySQL Query for selecting all fields from a table where the fieldvalues do NOT equal nothing?

Thanks!

Share this post


Link to post
Share on other sites
If only it was that simple... I assume you mean where all field value for a particular row are not blank.  Unfortunately, without actually checking each one, it's a pain, and even if you do, you'd have to change the column list dynamically, which you can't do either.  What are you trying to accomplish?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.