<div>
Use of the keyword binary to make a case sensitive query. This is from the mysql site<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html</a><br />
<br />
The following two statements illustrate that string comparisons are not case sensitive unless one of the operands is a binary string: <br />
<br />
mysql&gt; SELECT 'abc' LIKE 'ABC';<br />
&nbsp; &nbsp; &nbsp; &nbsp; -&gt; 1<br />
mysql&gt; SELECT 'abc' LIKE BINARY 'ABC';<br />
&nbsp; &nbsp; &nbsp; &nbsp; -&gt; 0
</div>


<div>
You might want to SELECT myColumn ... WHERE myColumn = 'XFTR' and see if the number of rows was more than one. &nbsp;Then use an iterator to aggregate all of the column values into an array, using the row id number as the array key and the value in myColumn as the value. &nbsp;When you have done that you will be able to use array_unique() to see if there are case-sensitive variants on the string in myColumn.<br />
<br />
Not sure I understand why a table structure could not be modified. &nbsp;ALTER TABLE is a fairly common MySQL command. &nbsp;But I also don't think it is needed to do what you want.
</div>


<div>
Hi,<br />
You could do something like this.<br />
<br />
SELECT stringname, (stringname NOT LIKE '%xftR') as Match where Match = 1 FROM yourtable;<br />
<br />
This will give you the output of all values that DONT MATCH your <br />
XftR &nbsp; &nbsp;0 <br />
xFTr &nbsp; &nbsp;0<br />
<br />
<br />
Then do an UPDATE WHERE (SELECT ...).<br />
<br />
I don't have any dummy data to test but the theory is there.<br />
<br />
Cheers,<br />
Hades6666
</div>


<div>
Thanks. Actually, the problem is a little more complex:<br />
<br />
The table structure:<br />
<br />
id &nbsp; &nbsp; string &nbsp; &nbsp; &nbsp; &nbsp;status &nbsp; &nbsp; time<br />
1 &nbsp; &nbsp; &nbsp;abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .<br />
1 &nbsp; &nbsp; &nbsp;Abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; . &nbsp;<br />
1 &nbsp; &nbsp; &nbsp;ABc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; . &nbsp; &nbsp; &nbsp; <br />
1 &nbsp; &nbsp; &nbsp;ABC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.<br />
<br />
I want to retrieve the string with status=1 and then all <br />
of the changes that may have occurred in the first, second and third <br />
character of the string. I do not know what the string is<br />
in advance. <br />
<br />
Thanks.<br />
<br />

</div>


<div>
You can use case sensitive (cs) collation:<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html</a>
</div>


<div>
<div class="content wysiwyg-content">
One field of a MySQL table is a string, each character of which is significant.<br />
For example, the string might be: &quot;XftR&quot;.<br />
At times, a new entry will be added, for example, &quot;xftR&quot;.<br />
<br />
Is there a SQL query that can identify and retrieve the differences?<br />
In the example, the result of such a query would be &quot;X&quot; has changed to &quot;x&quot;.<br />
The table structure cannot be modified. 
</div>
</div>


One field of a MySQL table is a string, each character of which is significant.
For example, the string might be: "XftR".
At times, a new entry will be added, for example, "xftR".

Is there a SQL query that can identify and retrieve the differences?
In the example, the result of such a query would be "X" has changed to "x".
The table structure cannot be modified. 

sql query string differences?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.