Re: [R] using variable in rmysql query

?paste id <- dbGetQuery(con1,paste("SELECT id FROM tenants WHERE name LIKE '%", ,str, "%'", sep = '')) On Sun, Nov 7, 2010 at 4:51 AM, Mohan L wrote: > Dear All, > > I am using this query it returns id : > > id <- dbGetQuery(con1,"SELECT id FROM tenants WHERE name LIKE '%consim%'") > > B

[R] using variable in rmysql query

Dear All, I am using this query it returns id : id <- dbGetQuery(con1,"SELECT id FROM tenants WHERE name LIKE '%consim%'") But In my case the string "consim" is there in another variable(it is coming from configuration file); > str <- "consim" I am trying to replace the string some this like,