Java、Mysql使用Like
在Mysql的数据库编辑器中写代码如下:
select * from powerbar where knowledgecode like '101%')
select * from powerbar where knowledgecode like '101''%'
select * from powerbar where knowledgecode like '?%'select * from powerbar where knowledgecode like ?%select * from powerbar where knowledgecode like ?'%'
select * from powerbar where knowledgecode like concat('101','%')