MySQL Forums
Forum List  »  Newbie

Re: broad match search results, splitting the search by spaces
Posted by: Joseph Charles
Date: November 11, 2014 01:10PM

Hi thank you for replying, im sorry but I don't understand your answer.

As you see from the different SQL queries that I have tried, I do store the length & height separately in the database, but they are stored as numbers without the mm,
so if someone searches for 21mm x 38mm it still wont match because the actual ProductName is 38mm x 21mm, the value in the length field is for example 21 not 21mm
and the same for the height field.

So I still wont get a match.

If you have an example SQL query that you think will work, please post an example so I can test it...

Joseph

Options: ReplyQuote


Subject
Written By
Posted
Re: broad match search results, splitting the search by spaces
November 11, 2014 01:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.