in reply to Re^2: DBI Substring index query and passing value
in thread DBI Substring index query and passing value

$name will be like "Christin".

Well, currently, $name is $name; single quotes don't interpolate. Do check how I modified your query code. (Also worth looking is 7548)