I have a field in which the user enters some text.If the user enters Bulevard London it finds the results but if he enters London Bulevard it doesn't find anything because in the database I have Bulevard London(example) and not London Bulevard.How can I make an sql query that searches for the words not the phrases?The user can also enter 5 words not only 2!
Thank you!
sql search
Moderator: General Moderators
Re: sql search
Assuming you're using MySQL, use Fulltext search.