in reply to Re: Using multiple values in a SQL "in" statementin thread Using multiple values in a SQL "in" statement
It's three operations. The x operator, is either a string or list multiplier. Here, it's being used on an list, as the item is in parens:
scalar(@id) gives the number of items in the array. So we end up with a list of question marks the same size as the @id array.
The join will flatten a list into a single string, placing the first argument in between each item. So we're placing a comma between each of the question marks.
DejaVu Sans Mono
Droid Sans Mono
Envy Code R
Source Code Pro
The default, whatever it is
Results (8 votes). Check out past polls.