Jump to content


Photo

SELECT FROM TABLE WHERE FIELDVALUE != ""


  • Please log in to reply
2 replies to this topic

#1 centenial

centenial
  • Members
  • PipPipPip
  • Advanced Member
  • 59 posts

Posted 03 July 2006 - 04:08 PM

Hi,

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

Thanks!

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 July 2006 - 04:28 PM

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?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 king arthur

king arthur
  • Members
  • PipPipPip
  • Advanced Member
  • 335 posts
  • LocationUK HQ

Posted 05 July 2006 - 02:43 PM

Do you mean "SELECT FROM table WHERE fieldvalue IS NOT NULL" ?
Sir Isaac Newton said "If I have seen farther, it is by standing on the shoulders of giants". But it is not recorded as to whether he said it before or after he was hit on the head by a falling apple.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users