mysql - 按关键字搜索 mySQL

Question

我正在尝试根据关键字查询表。我的 table 看起来像:

+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| id         | int(11)      | NO   | PRI | NULL    | auto_increment |
| username   | varchar(255) | YES  |     | NULL    |                |
| tweetBody  | varchar(255) | YES  |     | NULL    |                |
| datePosted | varchar(255) | YES  |     | NULL    |                |
| likes      | int(11)      | YES  |     | NULL    |                |
| dislikes   | int(11)      | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+

我正在尝试做的查询看起来像

SELECT * FROM tweets WHERE tweetBody LIKE'is';

我正在尝试查找所有包含作品"is"的推文，但没有返回任何结果。很明显我确实有包含 is 的推文。这是我当前的表格:

+----+----------+----------------------------------------------------------------------------------------------------------------+------------+-------+----------+
| id | username | tweetBody                                                                                                      | datePosted | likes | dislikes |
+----+----------+----------------------------------------------------------------------------------------------------------------+------------+-------+----------+
|  1 | ryan4664 | This is a tweeeeeeet!                                                                                          | 2015/08/09 |     0 |        0 |
|  2 | ryan4664 | Swag chillwave skateboard, roof party messenger bag jean shorts keytar gastropub DIY. Lomo shabby chic liter   | 2015/08/10 |     0 |        0 |
|  3 | ryan4664 | z YOLO slow-carb. Paleo Brooklyn pop-up whatever, hoodie tilde Odd Future semiotics tote b                     | 2015/08/10 |     0 |        0 |
|  4 | ryan4664 | ter distillery church-key meditation chillwave authentic polaroid direct trade. Aesthetic fixie Wes Anderson 9 | 2015/08/10 |     0 |        0 |
+----+----------+----------------------------------------------------------------------------------------------------------------+------------+-------+----------+

Answer 1

您需要在 like 中添加通配符搜索

SELECT * FROM tweets WHERE tweetBody LIKE '%is%';

% matches any number of characters, even zero characters.
_ matches exactly one character.