0

Could someone please guide me on how to use soundex in sqlite. or can we use "soundex" function in sqlite. if we can use it Please provide an example if possible. thanks in advance.

kksal55
  • 500
  • 7
  • 14
  • You use it just like any other SQL function. What exactly is the problem? – CL. Sep 28 '17 at 06:58
  • @CL. Currently if i search for example 'chir' then 'chair' won't show on the results. I want you to find out the "computer" result when I search for "compuzer". I use the like command when searching in sql query. but that is not enough. – kksal55 Sep 28 '17 at 08:07

1 Answers1

2

The soundex() function would have to be enabled with the SQLITE_SOUNDEX compile-time option. The Android framework does not do this.

CL.
  • 173,858
  • 17
  • 217
  • 259