mysql> show tablese;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tablese' at line 1
mysql> show tables;
+-------------------+
| Tables_in_homeuse |
+-------------------+
| DVDs |
+-------------------+
1 row in set (0.00 sec)
mysql> create table `badwords` (
-> `censor` varchar(255) NOT NULL default '',
-> PRIMARY KEY (`censor`)
-> ) type=MyISAM
-> ;
Query OK, 0 rows affected, 1 warning (0.08 sec)
mysql> show tables;
+-------------------+
| Tables_in_homeuse |
+-------------------+
| DVDs |
| badwords |
+-------------------+
2 rows in set (0.00 sec)
mysql> insert into badwords values('mypogobadges');
Query OK, 1 row affected (0.00 sec)
mysql> select * from badwords where censor like '%pogo%';
+--------------+
| censor |
+--------------+
| mypogobadges |
+--------------+
1 row in set (0.03 sec)
mysql>