simple select statements Code Script

| | | | |

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

Menu

Links

-	Script Editors