DB Query Examples

Query Examples

1. Find all definitions for a given Hebrew word
2. SELECT d.definition_type, d.definition_text FROM Definitions d JOIN Hebrew_Words hw ON d.word_id = hw.word_id WHERE hw.hebrew_word = 'אֲבִי';

Get all permutations for a word:

SELECT wf.formation, wf.formation_meaning

FROM Word_Formations wf

JOIN Hebrew_Words hw ON wf.word_id = hw.word_id

WHERE hw.hebrew_word = 'אמר';

Find typological meanings linked to a word:

SELECT t.typological_meaning, t.example_usage

FROM Typologies t

JOIN Hebrew_Words hw ON t.word_id = hw.word_id

WHERE hw.hebrew_word = 'שלום';

Get gates and their directional meanings:

SELECT g.gate, g.direction, g.gate_meaning

FROM Gates g

WHERE g.gate = 'אב';