SQL BETWEEN to define a range of rows

October 14th, 2011 by admin

Use SQL BETWEEN and AND to define a range of data between two values.

Example:

DELETE FROM `database_name`.`database_table` WHERE `database_table`.`TableRow` BETWEEN value1 AND value2

The two values can be numbers, dates or text.

Posted in Coding | No Comments »