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          |
 ================

    Zoho Pagesense Resources

        Zoho SalesIQ Resources



              Zoho TeamInbox Resources

                Zoho DataPrep Resources


                    Zoho CRM Plus Resources

                      Zoho Books Resources


                        Zoho Subscriptions Resources

                          Zoho Desk Resources

                            Zoho Projects Resources


                              Zoho Sprints Resources


                                Qntrl Resources


                                  Zoho Creator Resources


                                    Zoho WorkDrive Resources




                                        Zoho Campaigns Resources

                                          Zoho CRM Resources

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now