Query That Is NOT A CASE SENSITIVE QUERY

Query That Is NOT A CASE SENSITIVE QUERY

Hi,

How do you create a query that is not a  case sensitive and will show all data that has the same value from the first word?

For Example

  =================
| ID |  Account Name    |
 ---------------------------
| 1   |  Mike Studio        | 
| 2   |  Wonderland       |
| 3   |  mike studio        |
| 4   |  mike                   |
| 5   |  mike stdio          |
 ================

OUTPUT: 
  =================
| ID |  Account Name    |
 ---------------------------
| 1   |  Mike Studio        | 
| 3   |  mike studio        |
| 4   |  mike                   |
| 5   |  mike stdio          |
 ================