Topic: Search in two bound tables
I have two tables " Streets " and " Structures ". Structures are anchored to " to Streets " It is necessary to carry out search of the necessary structure having retrieval request in the form of the text (if retrieval the request is not exact - some results are possible).
Lines have as "", those different variations of a spelling (title: , sub_titles: |), those the street can have synonyms in a title. (The storage format can be any as you tell and I will store).
For example: " Chapaeva 14 ", " Chapaeva ", " street Chapaeva 14 ", " 14 Chapaeva "
` streets ` ( ` street_id ` smallint (5) unsigned NOT NULL AUTO_INCREMENT; ` title ` varchar (100) NOT NULL; ` sub_titles ` varchar (255) DEFAULT NULL; PRIMARY KEY (` street_id `) ); ` locations ` ( ` location_id ` smallint (5) unsigned NOT NULL AUTO_INCREMENT; ` street_id ` smallint (5) unsigned DEFAULT NULL; ` title ` varchar (100) NOT NULL; PRIMARY KEY (` location_id `) );
It is necessary to receive identifiers of structures approaching under retrieval request.
Any help and councils is useful. Even the request description in "human" language is simple, will try if that it to make.