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