How to construct sqlite query containing ampersand in filter:
SELECT i开发者_高级运维d FROM mediainfo WHERE album="Betty & Kate";
I use sqlite C interface (sqlite3_bind_text() and ? marks while query building) but neither C query nor SQLite Administrator return any data
&
is not a special character either in C strings or in SQL strings, so I don't think that's the problem. Try the same query from a tool like SQLite Database Browser.
精彩评论