gistfile1.txt

sqlite> SELECT * FROM blocks; 
id|name|guid|last_ip|created_at|updated_at|pubkey|user_id
34|||127.0.0.1|2012-01-02 08:17:14.595101|2012-01-02 08:17:14.595101|foobar|
sqlite> select * from blocks where last_ip='127.0.0.1';
sqlite> select * from blocks where pubkey='foobar';
id|name|guid|last_ip|created_at|updated_at|pubkey|user_id
34|||127.0.0.1|2012-01-02 08:17:14.595101|2012-01-02 08:17:14.595101|foobar|


and

sqlite> select * from blocks;
id|name|guid|last_ip|created_at|updated_at|pubkey|user_id
34|||127.0.0.1|2012-01-02 08:17:14.595101|2012-01-02 08:17:14.595101|333|
35|||127.0.0.1|2012-01-03 03:36:04.483322|2012-01-03 03:36:04.483322|foobar|
sqlite> select * from blocks where last_ip='127.0.0.1';
id|name|guid|last_ip|created_at|updated_at|pubkey|user_id
34|||127.0.0.1|2012-01-02 08:17:14.595101|2012-01-02 08:17:14.595101|333|
sqlite> select last_ip from blocks;
last_ip
127.0.0.1
127.0.0.1
sqlite> select distinct last_ip from blocks;
last_ip
127.0.0.1
127.0.0.1