'Where Condition on google auto complete address
I have a home search table with have a city column which can have multiple cities like "Avignon, France|Nantes, France|". Addresses are "|" separated. There's a other Ads table where home ads are stored and there's also a city column which can have only one city like "Avignon, France".
Now I have to search matching home searches which matched with ads city .
How I can query home searches ???
Currently using home.city LIKE "%' . $ad->city. '%". Which not return the 100 % correct results . I need 100% correct results .
Problem is when we match home searches for "Arbonne, France"
It display ads for "Narbonne, France" which is another city
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|