QtSql Fuzzy search

Question

I am working with QSQLITE database in qt and attempt to implement fuzzy search in our program our sql query is something like this:

select name from things where name like '%arg%'

it's not the same the query is longer has joins and etc. I tried using SOUND and SOUNDEX() but I think none of them is supported in QSQLITE is there any way I can implement fuzzy search here?

score 0 · Answer 1 · edited May 23 '17 at 12:03

0

For soundex support, you would have to recompile the SQLite library embedded in Qt.

There is no other built-in 'fuzzy' function. Either implement your own custom function, or store a normalized version of your string in the database so that you can compare it directly.

edited May 23 '17 at 12:03

Community

1
1

answered Mar 04 '14 at 09:39

CL.

173,858
17
217
259

I tried recompiling the SQLite with soundex but how can i embed it in qt? – Zoli Mar 04 '14 at 10:36
You have to recompile Qt. – CL. Mar 04 '14 at 11:48

QtSql Fuzzy search

1 Answers1