Answer the question
In order to leave comments, you need to log in
How to search MySQL for numbers starting with 0 (full text search)?
Base with users and addresses of residence. Some apartments are entered as "p06"
This query does not find anything
SELECT username, address FROM base WHERE MATCH (username,address) AGAINST ('+Энтуз* +36 +06' IN BOOLEAN MODE);
SELECT username, address FROM base WHERE MATCH (username,address) AGAINST ('+Энтуз* +36 +п06' IN BOOLEAN MODE);
SELECT username, address FROM base WHERE MATCH (username,address) AGAINST ('+Энтуз* +36 +6' IN BOOLEAN MODE);
SELECT username, address FROM base WHERE MATCH (username,address) AGAINST ('+Энтуз* +36 +16' IN BOOLEAN MODE);
Answer the question
In order to leave comments, you need to log in
Make an additional field that participates in the search, but is not displayed to the user.
When inserting a record with "apt. p06" enter "6 06" in the additional field.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question