PHPLarge -- FuzzyOffice -- Sidebar- Some Common SQL Examples

PHPLarge :: FuzzyOffice :: Sidebar: Some Common SQL Examples

Last updated: 8/20/2002; 4:03:01 AM

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

comment []