Advanced PHP SQL Bootstrap Search

Looking for an advanced search for the back end of a site. The site is built in bootstrap and php. The kind of thinks i'm looking for is to be able to search from multiple tables, multiple words and best matches. For example if i want to search for John Smith as a customer, I don't want all smiths or all johns, i want only john smith even though john is in one field in the table and smith is in the other. There are other tables that may contain John Smith. I want those to appear also. The last thing is that if i type John Smith and i spell Smith Smih, i would like it to try and return some results. If would be nice to have spelling not stop the search for working. I'm sure someone may already have the code for this.