search

mevdschee / php-crud-api

Single file PHP script that adds a REST API to a SQL database
MIT License
3.61k stars 1.01k forks source link

Could it be possible to add the filter SOUNDS LIKE? #801

Open albu77 opened 3 years ago

albu77 commented 3 years ago

It's interesting in some case when we want to check before creation for already existing record but with a close spelling.

mevdschee commented 3 years ago

I have done some research and it seems soundex is more or less supported by most engines (and thus we can compare based on soundex value):

*) This function is omitted from SQLite by default. It is only available if the SQLITE_SOUNDEX compile-time option is used when SQLite is built.