The LIKE operator of 07-sqlite

I. Overview of like

The like

operator is used to search for the specified pattern syntax in a column in a where sentence : Select column_name (S ) from table_name where column_name like pattern;

second, from the persons table, select addr with "s" Beginning data information

Syntax: SELECT * from persons where addr like ' s% '; Note: The% number above is a wildcard character (the missing part of the pattern), as long as the first letter is S

third, from the persons table, select addr with "J" End of the data information

Syntax: Select id,addr from persons where addr like '%j ';

Iv. Select data information from the persons table that contains "Z" in the addr

Syntax: SELECT * from persons where addr like '%z% ';

v. Select addr Data information from the persons table that does not contain "Z"

Syntax: SELECT * from persons where addrdon't like'%z% ' ;

The LIKE operator of 07-sqlite