> 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
Try this: select * from mytable where myfield like "%100%%"; Standard way for escaping "%" is "%%" in other databases :) -- H.Neikov --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
