You need to search for "%son's%" (or at least "%son's") to achieve a match.
-----Ursprüngliche Nachricht----- Von: sqliteuser0000 [mailto:tarmopropel...@outlook.com] Gesendet: Donnerstag, 16. Jänner 2014 08:53 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] How to bind parameters to LIKE with sqlite3_bind_text? Hi, sorry, that was a typo. The bind actually looks like this: sqlite3_bind_text(stmt, 1, search.c_str(), -1, SQLITE_STATIC); The string is guaranteed to live long. What else is wrong with this, why will it not match anything? Do i need to use the % symbols? E.g. If the DB contasin value "The Johnson's" and i search for "son's" it will not match anything :( -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-bind-parameters-to-LIKE-with-sqlite3-bind-text-tp73237p73274.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
