SQL Query
SELECT * FROM meme m0 WHERE m0.aid='george_washington' AND m0.qnt!=0;
Results
ARBQ
george_washingtonbirthgeorge_washington_birth1
george_washingtondeathgeorge_washington_death1
george_washingtonelectedpresidential_election_17891
george_washingtonmilitary_officerusa1
george_washingtonpartyindependent1
george_washingtonpersonvarious1
george_washingtonplantervarious1
george_washingtonpresident_orderfirst1
george_washingtonspousemartha_washington1
george_washingtonsurveyorvarious1
george_washingtontermlengthyear8
Memelang SQL Demo
This is demonstration of translating Memelang to SQL for querying relational databases. See the PHP code in GitHub. A Python version is coming soon. Example queries:
Show all data in this DB.
qry.all
All about George Washington.
george_washington
Who were children of the presidents?
.child
Which presidents were members of the Whig party?
.party:whig
Which presidents attended Harvard?
.college:harvard
Which presidents were born before 1820?
.birth.year:ad<1820
Which presidents attended Columbia and were lawyers?
.college:columbia .lawyer
Who were the twentieth through thirtieth presidents?
.president_order>=20 .president_order<=30
Which presidents attended a college that was not Harvard?
.college .college:harvard=f
Which presidents did not have children?
.president_order .child=f
Who were the spouses of the twentieth through thirtieth presidents?
.president_order>=20 .president_order<=30 .spouse
Use qry.all to return all memes related to the matching As.
.college:harvard .college:columbia qry.all
Get all about James Carter as well as Ronald Reagan.
james_carter; ronald_reagan
Which presidents were lawyers that attended Harvard or William and Mary?
.lawyer .college:harvard=t1 .college:william_and_mary=t1
What were the professions of the presidents?
?profession
Which presidents has children that became presidents?
.child.president_order