Enlighten
main * cfe6df1

Search feminbase in FEMININE_FORM field with partial word match

Request
Method: POST
Route: api/entry/search
Example: api/entry/search
Input Value
term αβαντ
database feminbase
search_mode partial
database_field FEMININE_FORM
Request Headers
host: localhost:8000
accept: application/json
user-agent: Symfony
content-type: application/json
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
content-length: 121
accept-language: en-us,en;q=0.5

Response
200 JSON
Response Headers
date: Sun, 01 Feb 2026 00:53:44 GMT
content-type: application/json
cache-control: no-cache, private 
{
    "data": [
        {
            "RECORD_NUMBER": 2,
            "LEMMA": "αβανταδόρος",
            "MASCULINE_FORM": "αβανταδόρος",
            "MASCULINE_SUFFIX": "-(α)δόρος",
            "FEMININE_SUFFIX": "-(α)δόρα",
            "FEMININE_CODE": "Α-2-α-b",
            "FEMININE_FORM": "αβανταδόρα",
            "FEMININE_FORM_STATUS": "ΠΡΟΤΕΙΝΟΜΕΝΟ",
            "CODE_DOCUMENTATION": "Α-2-α-b#https:\/\/www.eleto.gr\/download\/Linguistic%20subjects\/ELETO_Professional_feminine_nouns.htm#%CE%914110",
            "DATE_OF_RECORD": "2026-01-22 00:00:00"
        },
        {
            "RECORD_NUMBER": 1,
            "LEMMA": "αβανταδόρος",
            "MASCULINE_FORM": "αβανταδόρος",
            "MASCULINE_SUFFIX": "-(α)δόρος",
            "FEMININE_SUFFIX": "-(α)δόρισσα",
            "FEMININE_CODE": "Α-2-α-a",
            "FEMININE_FORM": "αβανταδόρισσα",
            "FEMININE_FORM_STATUS": "ΠΡΟΤΕΙΝΟΜΕΝΟ",
            "CODE_DOCUMENTATION": "Α-2-α-a#https:\/\/www.eleto.gr\/download\/Linguistic%20subjects\/ELETO_Professional_feminine_nouns.htm#%CE%914110",
            "DATE_OF_RECORD": "2026-01-22 00:00:00"
        }
    ],
    "system": {
        "messages": [],
        "status": 200,
        "status_text": "OK",
        "errors": [],
        "error_code": 0
    },
    "metadata": {
        "request": {
            "term": "αβαντ",
            "search_mode": "partial",
            "database_field": "FEMININE_FORM",
            "database": "feminbase"
        },
        "count": 2
    }
}

Time: 6.84

 
select * from `FEMINBASE_FEMINBASE` where `FEMININE_FORM` like ? order by `FEMININE_FORM` asc
Bindings
0: %αβαντ%

Time: 1.02

 
select * from `STATISTICS` limit 1

Time: 2.14

 
update `STATISTICS` set `feminbase_searches` = `feminbase_searches` + 1 where `id` = ?
Bindings
0: 1

Request
Method: POST
Route: api/entry/search
Example: api/entry/search
Input Value
term αβαντ
database feminbase
search_mode partial
database_field FEMININE_FORM
Request Headers
host: localhost:8000
accept: application/json
user-agent: Symfony
content-type: application/json
accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
content-length: 121
accept-language: en-us,en;q=0.5