On Feb 12, 2007 10:34 PM, Juan Pablo Garcia wrote:
> I want to find "aString" in the column "names" of a table "people"
> where I have 2 strings ("aString" and "bString" separated by a comma)
> I can´t see a replace command in Sqlite sintax.
I think that you must first get the records, change the data and then update
the table:
1. Get all records that contains (or starts with) "aString" in the column
"names";
2. Get the contents of each record for the column into a string and change it;
3. Do an UPDATE for those records.
Just a curiosity: are those "aString" and "bString" First and Last names? If
yes, it would be better to have them in different columns.
HTH
Carlos
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
