Category
- Php
- JAVA
- DOTNET
- Vbscript
- C
- vb
- html
- Mysql
- Oracle
- sql
- Db
- Computer
- Commerce
- Business
- Arts
- Cashier
- Audit
- Banking
- Accounts
- Math
- Physics
- Biology
- Others
Home >> Asked Questions >> Mysql
Q. how can write between query in mysql?
Answer :
SELECT *
FROM "table_name"
WHERE "column_name" BETWEEN 'value1' AND 'value2'
FROM "table_name"
WHERE "column_name" BETWEEN 'value1' AND 'value2'
Posted By : akash
Following statement ia also used in the BETWEEN function:
SELECT *
FROM student
WHERE dob between '1980-01-28' AND '2000-01-23';
SELECT *
FROM student
WHERE dob between '1980-01-28' AND '2000-01-23';
Posted By : akash
Most Viewed Questions