Do you have a question? Post it now! No Registration Necessary. Now with pictures!
March 24, 2007, 7:34 pm
rate this thread
Re: double entries
Yep. Assuming they really are exact doubles (phrase,space,phrase)
here's one way:
SELECT TRIM( SUBSTR(
fieldA, 1, FLOOR( LENGTH( fieldA ) /2 ) )
START , TRIM( SUBSTR(
fieldA, CEILING( LENGTH( fieldA ) /2 ) )
HAVING START = finish
LIMIT 0 , 30
I'll leave that as an execise for the reader. WARNING: BACK UP YOUR
DATA BEFORE YOU ATTEMPT THIS!!!
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum