I am trying to update a SQLite table in my Android application. Predicate for this update is built around a column which stores different resource URLs. 

These URLs might contain special characters such as /~?=; (and even &).

My query looks like:

```
update TableName where columnVal = '/some/fake/~/id?u=0&amp;rl=url';

```

The update query doesnt work; it does not identify the column satifying the condition.

How can I escape these characters?

Please advise.