mysql 数据表 查找 where and or

1. 数据表按条件查看 where

> select * from t_warn_storage where state=1;> select * from t_warn_storage where parameters="vcfs2";> select * from t_warn_storage where parameters="vcfs2" and state=1;

2. like 匹配 %通配符

> select * from t_warn_storage where  parameters like "vcfs3&core%";