If you want the exact string you say , in effect: COLUMN_NAME = 'my search string'
(single quotes) On Jan 12, 7:07 pm, "Hendrik Greving" <[email protected]> wrote: > KEY_STRING is the text column name > > When putting in KEY_STRING + " like " + mystring => I am getting a syntax > exception > KEY_STRING + " like \"" + mystring + "\"" => it seems to incorrectly always > find something > > Actually, I want only exact matches, no substrings anyways > > ----- Original Message ----- > From: Kostya Vasilyev > To: [email protected] > Sent: Wednesday, January 12, 2011 4:51 PM > Subject: Re: [android-developers] sqllite > > Try using "like": > > ... where column like "%substring%"... > > -- > Kostya Vasilyev --http://kmansoft.wordpress.com > > 13.01.2011 3:42 пользователь "Hendrik Greving" <[email protected]> > написал: > > I have a database with a primary integer row key and several columns. One > of the columns is "text". Normally I am only fetching for the key, which is > easy with SQLiteDataBase.query and KEY_ROWID = <mynumber> in the selection > field. How can I check whether a row (or more) exist that contain a certain > string in the text column. I've tried "MY_STRING_COLUMN = > \"my_search_string\"" in the selection argument, but this doesn't work. > > > -- > > You received this message because you are subscribed to the Google > > Groups "Android Developers" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > >http://groups.google.com/group/android-developers?hl=en > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
