MySQL queries are not case-sensitive by default. Following is a simple query that is looking for `&#39;value&#39;`. However it will return `&#39;VALUE&#39;`, `&#39;value&#39;`, `&#39;VaLuE&#39;`, etc…

```sql
SELECT * FROM `table` WHERE `column` = &#39;value&#39;
```

The good news is that if you need to make a case-sensitive query, it is very easy to do using the [`BINARY`][1] operator, which forces a byte by byte comparison:

```sql
SELECT * FROM `table` WHERE BINARY `column` = &#39;value&#39;
```

  [1]: https://dev.mysql.com/doc/refman/5.7/en/charset-binary-set.html

To improve [James&#39; excellent answer][1]:

It&#39;s better to put `BINARY` in front of the constant instead:

```sql
SELECT * FROM `table` WHERE `column` = BINARY &#39;value&#39;
```

Putting `BINARY` in front of `column` will prevent the use of any index on that column.


  [1]: https://stackoverflow.com/a/7857705/1480391

Whilst the listed answer is correct, may I suggest that if your column is to hold case sensitive strings you read [the documentation](http://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html) and alter your table definition accordingly.

In my case this amounted to defining my column as:

    `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT &#39;&#39;

This is in my opinion preferential to adjusting your queries.

I installed mySQL on my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preferences, I want to know the instructions to start from command-line.
I do as follows:

After

&gt; su root

I start the mySQL server by command-line, but it produces an error as below:

&gt; **sh-3.2#** /usr/local/mysql/bin/mysqld
&gt; 
&gt; **111028 16:57:43** [Warning] Setting lower_case_table_names=2 because
&gt; file system for /usr/local/mysql-5.5.17-osx10.6-x86_64/data/ is case
&gt; insensitive
&gt; 
&gt; **111028 16:57:43** [ERROR] Fatal error: Please read &quot;Security&quot; section of
&gt; the manual to find out how to run mysqld as root!
&gt; 
&gt; **111028 16:57:43** [ERROR] Aborting
&gt; 
&gt; **111028 16:57:43** [Note] /usr/local/mysql/bin/mysqld: Shutdown complete




How to start MySQL server from command line on Mac OS Lion?

I&#39;d like edit a file with sed on OS X.  I&#39;m using the following command:

    sed &#39;s/oldword/newword/&#39; file.txt

The output is sent to the terminal.  **file.txt** is not modified.  The changes are saved to **file2.txt** with this command:

    sed &#39;s/oldword/newword/&#39; file1.txt &gt; file2.txt

However I don&#39;t want another file.  I just want to edit **file1.txt**.  How can I do this?

I&#39;ve tried the -i flag.  This results in the following error:

    sed: 1: &quot;file1.txt&quot;: invalid command code f

In-place edits with sed on OS X

This has been asked on this site before but I couldn&#39;t find a sufficient answer. If I&#39;m doing a query like:

    Select Seller from Table where Location = &#39;San Jose&#39;

How can I make it return only Sellers with Location &#39;San Jose&#39; instead of &#39;san jose&#39; or something else?

MySQL case sensitive query

This has been asked on this site before but I couldn't find a sufficient answer. If I'm doing a query like:
<pre><code class="hljs language-sql">Select Seller from Table where Location = 'San Jose'
</code></pre>
How can I make it return only Sellers with Location 'San Jose' instead of 'san jose' or something else?

Could you help me solve this problem ?

When I try to click &quot;query database&quot; under database menu in Mysql workbench. it gives me an error:

&gt; Cannot Connect to Database Server
&gt;
&gt; Your connection attempt failed for user &#39;root&#39; from your host to server at 
    127.0.0.1:3306:Can&#39;t connect to mysql server on &#39;127.0.0.1&#39;(10061)
&gt;
&gt; Please:
&gt;
&gt; 1. Check that mysql is running on server 127.0.0.1
&gt; 2. Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
&gt; 3. Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines) 
&gt; 4. Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you&#39;re connecting from


Cannot connect to Database server (mysql workbench)

Here&#39;s how I do it:

 1. Table names are lower case, uses underscores to separate words, and are singular (e.g. `foo`, `foo_bar`, etc.
 2. I generally (not always) have a auto increment PK. I use the following convention: `tablename_id` (e.g. `foo_id`, `foo_bar_id`, etc.).
 3. When a table contains a column that is a foreign key, I just copy the column name of that key from whatever table it came from. For example, say table `foo_bar` has the FK `foo_id` (where `foo_id` is the PK of `foo`).
 4. When defining FKs to enforce referential integrity, I use the following: `tablename_fk_columnname` (e.g. furthering example 3, it would be `foo_bar_foo_id`). Since this is a table name/column name combination, it is guaranteed to be unique within the database.
 5. I order the columns like this: PKs, FKs, then the rest of columns alphabetically

Is there a better, more standard way to do this?



Is there a naming convention for MySQL?

What is the safest way to run queries on MySQL? I am aware of the dangers involved with MySQL and SQL injection.

However, I do not know how I should run my queries to prevent injection on the variables to which other users (webclients) can manipulate. I used to write my own escape function, but apparently this is &quot;not-done&quot;.

What should I use and how should I use it to query and do inserts safely on a MySQL database through python without risking MySQL injection?

Python: best practice and securest way to connect to MySQL and execute queries

I&#39;m running a server at my office to process some files and report the results to a remote MySQL server.

The files processing takes some time and the process dies halfway through with the following error: 

    2006, MySQL server has gone away

I&#39;ve heard about the MySQL setting, **wait_timeout**, but do I need to change that on the server at my office or the remote MySQL server?


MySQL error 2006: mysql server has gone away

I noticed that 

    HTTP://STACKOVERFLOW.COM/QUESTIONS/ASK

and 

    http://stackoverflow.com/questions/ask

both works fine - actually the previous one is converted to lowercase.

I think that this makes sense for the user.

If I look at Google then this URL works fine:

    http://www.google.com/intl/en/about/corporate/index.html&#160; 

but this one with &quot;ABOUT&quot; is not working:  

    http://www.google.com/intl/en/ABOUT/corporate/index.html&#160;  

Should the URL be case sensitive?


Should URL be case sensitive?

In the first commitment of my partial called `_Electronics` it was written beginning with a capital letters, then I changed it to `_electronics`.

Git under cygwin ignored the case after commiting the new name, so I changed the name by hand in the target repo.

Now it sometimes changes the commited `_electronics` partial to `_Electronics`.

What have I done wrong?

Is git not case sensitive?

I have a set of variables I allow some people I work with to edit. These are True (`T`) and False (`F`) values, but I have some people that insist on putting `t` and `f` instead of the upper case values respectively. 

I use the following workaround code to properly set uppercase values:

    IF &#39;%dotnet35%&#39;==&#39;f&#39; set dotnet35=F
    IF &#39;%dotnet35%&#39;==&#39;t&#39; set dotnet35=T
    IF &#39;%dotnet40%&#39;==&#39;f&#39; set dotnet40=F
    IF &#39;%dotnet40%&#39;==&#39;t&#39; set dotnet40=T
    IF &#39;%regedit%&#39;==&#39;f&#39; set regedit=F
    IF &#39;%regedit%&#39;==&#39;t&#39; set regedit=T
    IF &#39;%SSL%&#39;==&#39;f&#39; set SSL=F
    IF &#39;%SSL%&#39;==&#39;t&#39; set SSL=T

This is however extremely bulky and it&#39;s not easy on the eyes... is there any other way of doing this without using VBS or any other programming language?

Windows batch command to ignore case sensitivity in variables

I&#39;ve run into a problem with git. Basically I set to false `core.ignorecase` because I wanted to change the case of the names of some folders (since I&#39;m under OSX with a case-insensitive filesystem, the changes weren&#39;t shown otherwise). When I pulled my data, I&#39;ve noticed that now every renamed folder appears twice on the repository, with both the old and the new name. I don&#39;t know what to do to remove the old folders since they don&#39;t appear locally (I&#39;ve try to set `core.ignorecase` to true again but it isn&#39;t helping).

Case sensitivity in Git

I have the following:

&lt;!-- language: lang-js --&gt;

    if (referrer.indexOf(&quot;Ral&quot;) == -1) { ... }

What I like to do is to make `Ral` case insensitive, so that it can be `RAl`, `rAl`, etc. and still match.

Is there a way to say that `Ral` has to be case-insensitive? 

Content Type	Original Author	Original Content on Stackoverflow
Question	Michael Liao	View Question on Stackoverflow
Solution 1 - Mysql	James mason	View Answer on Stackoverflow
Solution 2 - Mysql	Shenxian	View Answer on Stackoverflow
Solution 3 - Mysql	Thomas Clowes	View Answer on Stackoverflow

MySQL case sensitive query

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

In-place edits with sed on OS X

How to start MySQL server from command line on Mac OS Lion?

Attributions