yerunting的博客

8.IN Operatorspecify multiple values in a WHERE clause1.IN SyntaxSELECT column_name(s)FROM table_nameWHERE column_name IN (value1, value2, ...);or；SELECT column_name(s)FROM table_nameWHERE c...

6.LIKE Operatorused in a WHERE clause to search for a specified pattern in a columntwo wildcards% - The percent sign represents zero, one, or multiple characters_ - The underscore represents a ...

1.NULL ValueA NULL value is different from a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation!1.SyntaxS NULL SyntaxSEL...