Question

我有用户表

ID   Name

1    Michael
2    Jimmy

如果从用户中挑选* ;然后回到第1行,就能够用部分名进行询问。

select * from user where name =  mic ;

就像名称一样,它从奇头开始,如何能够在MySql返回好战的行。

Answer 1

You need the LIKE clause and add an appropriate wildcard.

select * from user where name like  mic%

http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html” rel=“nofollow”

使用“_”与任何单一特性相匹配,“%”与任意性质(包括零性)相对应

配对模式

SQL pattern matching enables you to use “_” to match any single character and “%” to match an arbitrary number of characters (including zero characters). In MySQL, SQL patterns are case-insensitive by default. Some examples are shown here. You do not use = or <> when you use SQL patterns; use the LIKE or NOT LIKE comparison operators instead.

Answer 2

USE LIKE % wildcard

select * from user where name like  mic% ;

Answer 3

 Select * from user where name like  mic%

Answer 4

Use like.

select * from user where name like  mic% ;

Answer 5

select * from user where name like  mic% ;

友情链接