搜索功能实现数据库like

Like用来匹配一部分的，% 任何字符出现任何位置区分大小写。

SELECT * FROM TABLE WHERE col Like '%a';//检索以a结尾的内容

SELECT * FROM TABLE WHERE col Like '%a%';//检索包含a的内容

SELECT * FROM TABLE WHERE col Like 'a%';//检索以a开头的内容

SELECT * FROM TABLE WHERE col Like 'a%b';//检索以a开头以b结尾的内容

例子：

SELECT * FROM movie WHERE created_date like '%04%';

SELECT * FROM movie WHERE created_date like '%05';

SELECT * FROM movie WHERE created_date like '2016%';

SELECT * FROM movie WHERE created_date like '2017%13';