Here is a made up query
"select * from tbl where name like '@foo%'" ... cmd.addparam(foo, bar) //not actual code
I get 0 results. I tried changing the where to
name like @foo and wrote bar+"%" however i suspect that is incorrect (it should escape %?) and i got 0 rows yet again.
How do I like with parameters? My code actually uses dapper.net with mysql as its database.
You need to construct your query as follows:
"select * from tbl where name like @foo"
cmd.addParam("@foo", bar + "%")