php-crud-api icon indicating copy to clipboard operation
php-crud-api copied to clipboard

Could it be possible to add the filter SOUNDS LIKE?

Open albu77 opened this issue 4 years ago • 1 comments

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

albu77 avatar Aug 05 '21 16:08 albu77

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):

  • SOUNDEX (mysql)
  • SOUNDEX (sql server)
  • soundex (postgres)
  • soundex (sqlite*)

*) 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.

mevdschee avatar Aug 23 '21 06:08 mevdschee