SQL server fuzzy query

Fuzzy query -- like

Select * from table name where id like '% 100'

 

Select * from table name where id like 'd % 'escape 'D'

 

During the query, the content in the field does not necessarily match the query content, as long as the field contains the content

 

Fuzzy query -- is null

Select * from table name where name is null

Query records with empty content in a field

 

Fuzzy query -- between and

Select * from table name where time between 2008-01-12 and 2008-05-12

Query records in a specific range of fields

 

Fuzzy query-in

Select * from table name where condition in ('first value', 'second value', 'third value', 'Fourth value ')

Query records that match the content in a field with the list of queried content.