[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] delete empty entries
From:       Frank Baumgart <godot () uni-paderborn ! de>
Date:       2004-12-12 12:28:49
Message-ID: 41BC3981.9090005 () uni-paderborn ! de
[Download RAW message or body]

Win a 2 wrote:
> Hello sqlite-users,
> 
>   want to delete all users from my teamspeakdatabase which nerver
>   logged in. but it doesn' work.
>   "delete from ts2_clients where dt_client_lastonline=NULL" or
>   "...=''" doesn't work.
>   BUT "select * from ts2_clients where dt_client_lastonline<>'';"
>   returns all clients which have logged in.

try "... is null"

[prev in list] [next in list] [prev in thread] [next in thread]