mysql - 如何在MySQL中搜索带有H的名字？

Question

它应该很简单，但它不起作用

 SELECT * FROM profile WHERE name LIKE = 'H%';
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 '= 'H%'' at line 1

表中的列

SHOW COLUMNS FROM profile;
+-------+-------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type                                                        | Null | Key | Default | Extra          |
+-------+-------------------------------------------------------------+------+-----+---------+----------------+
| id    | int(10) unsigned                                            | NO   | PRI | NULL    | auto_increment |
| name  | varchar(20)                                                 | NO   |     | NULL    |                |
| birth | date                                                        | YES  |     | NULL    |                |
| color | enum('blue','red','green','brown','black','white')          | YES  |     | NULL    |                |
| foods | set('lutefisk','burrito','curry','eggroll','fadge','pizza') | YES  |     | NULL    |                |
| cats  | int(11)                                                     | YES  |     | NULL    |                |

我应该尝试什么？

Answer 1

在 select 语句中删除 =所以；

 SELECT * FROM profile WHERE name LIKE  'H%';