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

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Programming resources »