# SQL 

### 

```sql
select name from user where id not in (1,3,4);
```
:

```
select name from user where id in (2,5,6);
```

### 
:

```sql
select name from user where name like '%zhangsan'
```

:
```sql
select name from user where name like 'zhangsan%'
```
 `Lucene` 

### 

 user 

###  null


### 

```sql
select name from user where FROM_UNIXTIME(create_time) < CURDATE();
```

:

```sql
select name from user where create_time < FROM_UNIXTIME(CURDATE());
```

### 

 user  username pwd SQL :

```sql
select username from user where username='zhangsan' and pwd ='axsedf1sd'

select username from user where pwd ='axsedf1sd' and username='zhangsan'

select username from user where username='zhangsan'
```



```sql
select username from user where pwd ='axsedf1sd'
```


### 

```sql
select name from user where username='zhangsan' limit 1
```


### 

```sql
select name from user where telno=18722222222
```



```
select name from user where telno='18722222222'
```

###  join