Does anyone know what's wrong with the following sql statement?
var GetItemByNameSql:String = "SELECT id FROM items WHERE name LIKE '%:name%'";
I've got an error saying that parameter :name is not in the SQL.
when i remove the % symbol it is fine but then the statement will only return the whole word match.
Does this mean i cannot use % together with parameter?