is this what you want" > x <- c(1, 2, 3, 4, 5) > paste0("where ASSETT in (", paste(x, collapse = ','), ")") [1] "where ASSETT in (1,2,3,4,5)"
On Fri, May 17, 2013 at 11:46 AM, Manta <mantin...@libero.it> wrote: > Hi all, > > I have a vector of numbers, and to be able to pass it to RMySQL and use the > IN clause I need to have this vector to be a single list numeric and comma > separated. > > I saw the post below but it is about strings, which I do not need (I cannot > pass strings in this SQL query, I need something like ' where ASSETT in > (1,2,3,4,5)' > > > http://stackoverflow.com/questions/6347356/creating-a-comma-separated-vector > > > Any clue? > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/Comma-separated-vector-tp4667340.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.