I have a customer table like this

id | city          | street            | street number
1  | Berlin        | Bahnhofstraße     | 5
2  | New York      | Main street       | 22
3  | Frankfurt     | Bahnhofstraße     | 11
4  | London        | Bond Street       | 63

I made a simple html input, get the value with jquery and perform an simple search with ajax.

So when i search for "Bahnh" i fire the SQL query

SELECT * FROM `customers` WHERE `street ` LIKE '