Code Script .co.uk

Home | Scripts | Tutorials | Disclaimer | Sitemap | Contact

   Simple Select Statements
 

Reference / Mysql / Simple Select Statements

Select rows where 'field' is none of the values in the array.

SELECT * FROM table WHERE field NOT IN ('str1','str2','str3')

Select rows where 'field' is between 'val1' and 'val2'.

SELECT * FROM table WHERE field BETWEEN 'val1' AND 'val2'





Please note that a disclaimer applies to any code on this page.
 
   Actions
  Go Back
  Bookmark
  Print Page


   Menu
 
- Links
- Reference
     - Javascript
     - Mysql
          - Simple Select Statements
     - Php
     - Standards
     - Windows Os
- Script Editors
- Tutorials
- Vbscript