SELECT FROM TABLE WHERE FIELDVALUE != ""

[centenial]

Hi,

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

Thanks!

[bradgrafelman]

You pretty much just spelled it out in your post title:

SELECT * FROM `myTable` WHERE `fieldName` != ""

[centenial]

bradgrafelman wrote:

You pretty much just spelled it out in your post title:

SELECT * FROM `myTable` WHERE `fieldName` != ""

Thanks, but is there a way where you can select ALL fields that do not have a value of "" (empty string)?

[bradgrafelman]

I don't get your question... you mean only return rows where every column has a value?

[jheitz]

If I understand correctly (not to sure to be honest:

Get bradgrafelman's query and add all the table's fields with an AND or OR statement (depending on if you are interested in rows that have all fields blank, this should never be possible if you have a PK anyways; or if you want any row that has at least one field empty)

[dr_bung]

centenial wrote:

Hi,

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

Thanks!

If nulls are allowed

SELECT * FROM table WHERE field IS NOT NULL

if nulls not allowed something like this might do the trick

SELECT * FROM table WHERE CHAR_LENGTH(field) > 0