Menu
01101110 01100101 01110100 01110111 01101111 01110010 01101011 01100001 01100100 01101101 01101001 01101110 01110100 01101111 01101111 01101100 01110011 00001101 00001010

Background

Manage Engine

Our readers provide the funding for our platform, and we may receive a commission when you make a purchase using the links on our site.

Using MCJ to Practice SQL Commands – Part 3 – Some Queries

/ October 3, 2016 — Database

Mountain Climbing Journal (MCJ) is a journal application that includes a SQL Tool to query the database using an embedded SQLite database engine. In Part 2 we created some records. Now, let’s do some queries. Our first query will be to select all fields in all records in the journal table:

select * from journal

s6

Select all fields in all records in the journal table that contain “the”:

select * from journal where entry like '%the%'

s7

Select one day ago:

select date('now','-1 days')

s8

Select all fields in all records in the journal that are older than one day ago:

select * from journal where date < date('now','-1 days')

s9

Show the table structure of the journal table using the SQLite PRAGMA command:

PRAGMA table_info(journal)

s10

Information

About