Searching data
- Created by: Tomiwaq
- Created on: 07-05-19 18:13
View mindmap
- Searching data
- SELECT and FROM
- SELECT is followed by the names of the fields you want
- FROM is followed by the name of the table you want to search
- WHERE
- WHERE specifies conditions that a record must satisfy
- AND and OR can be used in a more precise WHERE search
- LIKE can be used to find a pattern
- ORDER
- ORDER BY is used to sort records into ascending or descending
- SELECT and FROM
Comments
No comments have yet been made