Displaying 1 result from an estimated 1 matches for "consim".
Did you mean:
consid
2010 Nov 07
1
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, but it not working:
> id <- dbGetQuery(con1,"SELECT id FROM tenants WHERE...