WOLFRAM

Wolfram Language & System Documentation Center

SQLMemberQ[data,column]

specifies a condition in an SQL query used to test whether an element of a list matches the value of a column.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLMemberQ

SQLMemberQ[data,column]

specifies a condition in an SQL query used to test whether an element of a list matches the value of a column.

Details and Options

Examples

Basic Examples  (1)

Wolfram Language code: Needs["DatabaseLink`"]

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["publisher"];
Wolfram Language code: SQLSelect[conn, "ROYSCHED", {"TITLE_ID", "ROYALTY"}, SQLMemberQ[{.14, .16}, SQLColumn["ROYALTY"]]]
Wolfram Language code: CloseSQLConnection[conn];