On Feb 10, 2006, at 16:51, malcom wrote:
Hello,
I have a sqlite column with a string. This string is composed by n
different lines separated by an \n character. Each line is composed by
<key>: <value>. So my final string is something like this:
<key_1>: <value_1_bla_bla>\n
<key_2>: <value_2_bla_bla>\n
<key_3>: <value_3_bla_bla>
Now I need to search *only* inside a particular key value. For example
I would to see if the value of key_2 contains a string 'test' (and if
possible return the entire value of key key_2).
Is it possible? My solution is to use regular expression (anyone can
hep me? I don't know more about them).
Let me double-check the problem: you are given the text, then key_2,
and then you need to search whether key_2 contains "text"? I guess
this is not the case because otherwise it would be trivial. How is
the "particular key" to search in specified? An index? Or is that you
need to fetch all the keys that contain "text"? In which programming
language?
-- fxn
