Re: [sqlite] Query to remove duplicate values ​​in a field?

I tried this way but it does not work UPDATE September Notes Recipes = Replace (Notes, | |, 'Location:') where is the mistake? > is there a way to update a field in this way? > > Fieldtoupdate: > 1) Location: Rome. Location: New York. > 2) Location: Florence. Location: Tuscany. Place: Arezzo

Re: [sqlite] Query to remove duplicate values ​​in a field?

On 27 Mar 2012, at 5:12pm, Alessio Forconi wrote: > is there a way to update a field in this way? > > Fieldtoupdate: > 1) Location: Rome. Location: New York. > 2) Location: Florence. Location: Tuscany. Place: Arezzo > > I want to update in this manner: > 1) Location: Rome.

[sqlite] Query to remove duplicate values ​​in a field?

Hello everyone, is there a way to update a field in this way? Fieldtoupdate: 1) Location: Rome. Location: New York. 2) Location: Florence. Location: Tuscany. Place: Arezzo I want to update in this manner: 1) Location: Rome. Lazio. 2) Location: Florence. Tuscany. Arezzo It can be done with a