Dunnigan Pierce wrote: > hi, sorry if this has been asked before or is hidden somewhere in the > documentation. couldn't find an archive of this list to search through and > couldn't find it in the docs. > > how do you escape " and % in sqlite? in other dbs you can do something like: > > > select * from mytable where myfield like "%100[%]%"; > > or > > select * from mytable where myfield like "%100\%%"; > > but neither seem to work with sqlite >
You cannot. At least not yet. See ticket #324. http://www.sqlite.org/cvstrac/tktview?tn=324.
As an interim workaround, you could defined your own "like()" function using the sqlite_create_function() API that implemented built-in escapes. Any user-defined function named "like()" is used to implement the LIKE keyword of SQL.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
