How to use basic SQL queries with cbJisho:

Start the search with a forward slash ("/"). The following will automatically be prepended to the query (so don't type it):  SELECT * FROM Dict WHERE

You may use the following columns: Note: The "Whole Word" and "RegEx" options have no effect when using SQL.

Examples:

  1. Find entries where the kanji starts with "時":
    /kanji like '時%'
  2. Find entries where the kanji is 3 characters and the middle character is "時":
    /kanji like '_時_'
  3. Find entries where the definition contains "candy" and the kanji contains "子":
    /def like '%candy%' and kanji like '%子%'
  4. Find godan verbs for "love" or "hate":
    /def like '%v5%' and (def like '%love%' or def like '%hate%')
  5. Definition contains "tiger" and the kana has fewer than 4 characters:
    /def like '%tiger%' and length(kana) < 4
  6. Find entries where the novel frequency is at least 99.0:
    /novel >= 99.0
  7. Find entries where the definition contains "US" but not "us" or "Us":
    /def glob '*US*'

Most useful SQL operators to use with cbJisho: