mysql> create table tmp3(
    -> tm timestamp null,
    -> message varchar(50) null
    -> );
Query OK, 0 rows affected (0.06 sec)

mysql>
mysql> insert into tmp3 values('1996-11-11','a CONNECTED b');
Query OK, 1 row affected (0.00 sec)

mysql> insert into tmp3 values('1996-10-11','sdf CONNECTED b');
Query OK, 1 row affected (0.00 sec)

mysql> insert into tmp3 values('1996-11-12','sdfs CONNECTED sdfsd');
Query OK, 1 row affected (0.00 sec)

mysql> insert into tmp3 values('1996-11-13','a COND b');
Query OK, 1 row affected (0.00 sec)

mysql> insert into tmp3 values('1996-11-14','a CONNTED b');
Query OK, 1 row affected (0.00 sec)

mysql> CREATE TEMPORARY TABLE t1
    -> SELECT tm, MESSAGE FROM tmp3
    -> WHERE MESSAGE LIKE "% CONNECTED %";
Query OK, 3 rows affected (0.04 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql>
mysql> select * from t1;
+----------------+----------------------+
| tm             | MESSAGE              |
+----------------+----------------------+
| 19961111000000 | a CONNECTED b        |
| 19961011000000 | sdf CONNECTED b      |
| 19961112000000 | sdfs CONNECTED sdfsd |
+----------------+----------------------+
3 rows in set (0.00 sec)

mysql>