The IN operator is a logical operator that allows you to test whether a specified value matches any value in a list. SQL Server IN operator overview. Now this will search for value anywhere in the column, and give the result.
But this also comes with another complication, it gives the result only if is present side by side of each other, if the column has or or even it will not list these records. Now coming to your question `WHERE `choices` IN (6)`, will. If you use the lower form of this condition (with multiple expressions to the left of the operator), then you must use the lower form of expression_ list , and the expressions in each expression_ list must match in number and datatype the expressions to the left of the operator.
This can be useful in scenarios where you have a comma-separated list of IDs, and you want to query your database for rows that match those IDs. Si potrebbe desiderare di selezionare in modo condizionale dei dati presenti in una tabella. Merge two dicts in separate list by id. How to retreive id from table that auto creates id. For ad hoc sql i can create stored procedures using ref cursors and sys_contexts in order to create dynamic WHERE clauses as determined by what the client passes in, using your methods of a variable IN list etc.
However do i need to create a separate stored procedure for every simple sql statement that selects from a different table?