A.R:B=Q
andrew_johnson.birth_country:usa=1
andrew_johnson.birth_state:north_carolina=1
andrew_johnson.birth_year:ad1808=1
andrew_johnson.child:and_william_johnson=1
andrew_johnson.child:andrew_johnson=1
andrew_johnson.child:charles_johnson=1
andrew_johnson.child:martha_johnson_patterson=1
andrew_johnson.child:robert_johnson=1
andrew_johnson.death_year:ad1875=1
andrew_johnson.election_year:ad1865=1
andrew_johnson.occupation:congressman=1
andrew_johnson.occupation:senator=1
andrew_johnson.occupation:tailor=1
andrew_johnson.occupation:tennessee_governor=1
andrew_johnson.party:democratic=1
andrew_johnson.pres_order:first=17
andrew_johnson.spouse:eliza_mccardle_johnson=1
andrew_johnson.time_served:year=3
/* SQL */
SELECT * FROM meme WHERE aid='andrew_johnson' AND qnt!=0;
Example Queries (Help)
qry.all Show all data in this DB.
george_washington All about George Washington.
.child Who were children of the presidents?
:lawyer Which presidents were lawyers?
.college:harvard Which presidents attended Harvard for college?
.pres_order=10 Who was the tenth president?
.college:columbia .occupation:lawyer Which presidents attended Columbia and were lawyers?
.pres_order>=20 .pres_order<=30 Who were the twentieth through thirtieth presidents?
.pres_order .child=f Which presidents did NOT have children?
.pres_order>=20 .pres_order<=30 .spouse=g Who were the spouses of the twentieth through thirtieth presidents?
.college:harvard .college:columbia qry.all Use qry.all to return all memes related to the matching As.
james_carter; ronald_reagan Get all about James Carter as well as Ronald Reagan