Code Script

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.
  Go Back
  Print Page

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