The FuzzyBlog!
Marketing 101. Consulting 101. PHP Consulting. Random geeky stuff. I Blog Therefore I Am.
PHPLarge :: FuzzyOffice :: Sidebar: Some Common SQL Examples
Listed below are some of the SQL expressions I used fairly regularly in the writing of this book and the FuzzyOffice product. Some are undoubtedly MySQL Specific
How to query a null field:
UPDATE fo_tasks SET user_id='1' WHERE user_id IS NULL;How to query a field that isn't null:
SELECT contact_id, lastname, firstname FROM `fo_contacts` WHERE lastname IS NOT NULL LIMIT 150