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 []

 
Copyright 2002 © The FuzzyStuff