[android-developers] SQL query issue

HI all,

I found this is a weird issue :(

I type this command:

C:\android-sdk-windows\tools>adb shell sqlite3 /data/data/com.android.browser/databases/browser.db 'select count(url) from bookmarks where url like %www.android.com%'

I want to run this query: 'select count(url) from bookmarks where url like %www.android.com%'

and the error is:
SQL error: near "%": syntax error

Do I need to write the query differently or need to add anything before typing special char??

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en