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:
-
kanji kana def (TEXT) The kanji, kana and definition columns.
-
overall blog news novel (REAL) Frequency columns. Range: [0-100] or -1.
-
jlpt (INTEGER) The JLPT column. Range: [1-5] or -1.
-
common (INTEGER) The (P) column. Range: [0-1].
Note: The "Whole Word" and "RegEx" options have no effect when using SQL.
Examples:
-
Find entries where the kanji starts with "時":
/kanji like '時%'
-
Find entries where the kanji is 3 characters and the middle character is "時":
/kanji like '_時_'
-
Find entries where the definition contains "candy" and the kanji contains "子":
/def like '%candy%' and kanji like '%子%'
-
Find godan verbs for "love" or "hate":
/def like '%v5%' and (def like '%love%' or def like '%hate%')
-
Definition contains "tiger" and the kana has fewer than 4 characters:
/def like '%tiger%' and length(kana) < 4
-
Find entries where the novel frequency is at least 99.0:
/novel >= 99.0
-
Find entries where the definition contains "US" but not "us" or "Us":
/def glob '*US*'
Most useful SQL operators to use with cbJisho:
-
and or not ( ) = != > < >= <=
-
like Search for a pattern in a column. Uses the following wildcard characters:
-
% Wildcard substitute for zero or more characters
-
_ Wildcard substitute for exactly one character
-
glob Similar to like except case senstive and uses the following wildcards:
-
* Wildcard substitute for zero or more characters
-
? Wildcard substitute for exactly one character
-
[charlist] Wildcard substitute for any character in charlist
-
[^charlist] Wildcard substitute for any character not in charlist
-
length(column) The number of characters in a column