Re: No Data on table

Hi Christian, Thanks for the reply. I got the table repaired and deleted some data on it. What combination can i use to overcome the 4GB limit? TIA Regards, Nhadie Christian Hammers wrote: Hello On 2007-02-18 Nhadie wrote: I had an error that my database is already full, when i do a sel

Comparing to a part of a string

Hi All, Is there a faster way of doing this query SELECT t1.to_uri as to_uri, t1.from_uri as from_uri, t1.sip_from as sip_from, t1.username as username, DATE(t1.time) as startdate, t1.time as start, t2.time as stop, TIMEDIFF(t2.time,t1.time) as timediff FROM acc AS t1 INNER JOIN acc AS t2 ON t