开发者

Ampersand in sqlite query

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜