search - Searching Mysql for simillar string -

People have different ideas about how to search for the same period.

For example Tri-valley, Tigri, Trie Valley (and possibly misspelled)

Currently this search is like this

  SELECT * FROM 'table' where '% tri valley%' like 'school district';  

There is no easy way to say 'space dash or no space' without writing three types of statements?

It seems that it can be done easily:

  'table' from SELECT * where '% tri% valley' like 'school district';  

But it works only when the initial input is 'triangular valley' or 'triangular valley' if the initial input is 'triqueline', then I do not know where to place% ( Theoretically, in fact, I do, because we are only seeing about a dozen different school districts, but I am trying to solve the big problem).

If you consider using , Or if you have many misspellings, if you are getting many lines (or even you do not), then store the output of SOUNDEX in an additional column To be intelligent.

i In the interest of accuracy - The school also recommends introducing a separate table with an official list of districts and running a query to find those lists.