Question: ```
1. select count(*) from tableX where code = "XYZ";
2. select count(*) from tableX where code like "%XYZ";

```

Result for query 1 is 18734. <== Not Correct

Result for query 2 is 93003. <== Correct

We know that query 2's count is correct based on independent verification.

We expect these two queries to have the exact same count for each because we know that **no rows in tableX have a code that ends with "XYZ"**, so the wildcard at the beginning shouldn't affect the query.

***Why would these queries produce different counts?***

We have already researched the differences between "=" comparison and "like" string comparison, but based on all our verification checks, we still don't understand why this would give us different counts

We have confirmed the following:

* There are no leading or trailing characters in the "code" field
* There are no hidden characters (tried all found here: [How can I find non-ASCII characters in MySQL?](https://stackoverflow.com/questions/401771/how-can-i-find-non-ascii-characters-in-mysql))
* The collation is "utf8\_unicode\_ci"

We are using MySQL version 5.5.40-0ubuntu0.12.04.1.

Answer: 
You should not delete this folders if you have old (DNX-based) projects that you still want to run. Otherwise, you will need to reinstall the dnx runtimes again to work with your old (RC1) apps.

Your new (RC2, `dotnet cli`) projects will known nothing about this old dnx-based folder and will ignore it completely.
Microsoft advise you to remove any old version of .Net Core. The DNX was the runtime and toolset used to build .Net Core and .Net Core apps as per Microsoft. It was consisted of DNVM, DNX and DNU.

With the .Net Core CLI all above (DNVM, DNX and DNU) are part of a single toolset.

You'll may find some issues when removing DNX, also when migrating a existing solution on any beta/rc version of clr or coreclr which were (dnxcore50 or dnx46) and [others](https://github.com/dotnet/corefx/blob/master/Documentation/architecture/net-platform-standard.md#deprecated-monikers) deprecated now.

> 
> NOTE: when uninstalling MS ASP.NET 5 RC1 Update 1 (old version), you
>  may have issues on your VS 2015 regarding to some projects templates,
>  existing MVC or WebAPI projects may not load.
> 
> 
> 

I'd suggest you to migrate to .Net Core 1.0 as I did in my side, it was a little pain but you won't go anywhere with a project target to a deprecated version.

You can follow these links to migrate your app:

1) <https://chsakell.com/2016/05/21/migrating-asp-net-5-rc1-apps-to-asp-net-core/>

2) <http://dotnet.github.io/docs/core-concepts/dnx-migration.html>