MySQL Forums
Forum List  »  Full-Text Search

Problem with license plate earching
Posted by: Frank van der Heijden
Date: June 28, 2006 04:55AM

Hello,

we have an application for car dealers that store records with license plate information. The Ducth license plates look like NN-CC-CC where N=Numeric, C=Characters.

Now we try to find records back by searching on the plate. Part of the query looks like:

SELECT * FROM CarTable
WHERE
(MATCH (LicensePlate) AGAINST '+81-LZ-RN*' IN BOOLEAN MODE)

This returns nothing. I understand this because we use + and - that are translated as AND / NOT

We have tried without the IN BOOLEAN MODE flag, also tried like

SELECT * FROM CarTable
WHERE
(MATCH (LicensePlate) AGAINST '"81-LZ-RN'"))

Still no results.

Is there anyone who can help me to solve this problem so that we can use the full text capabilities on license plates?

With kind regards

Frank van der Heijden
KN BV
The Netherlands
Mail : heyden66@planet.nl

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with license plate earching
3165
June 28, 2006 04:55AM


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.