I've got a cell array like this sinkname = [washington newyork seattle]
and I'm connecting to a database and trying to extract the rows of data that have the exact same sinknames with the above cell array.
So I wrote the command like this: cur = exec(conn,'select city,people from map where city in sinkname');
I tried to add brackets/quotes/parenthesis around sinkname in the above command, but nothing worked.
What is the correct format of writing such query? Or is it impossible to set a where criteria like this?
My real cell array is very large so I can't type all the names in the 'where' criteria.
Thank you guys for help!