P
P
Peter2015-10-27 23:04:45
MySQL
Peter, 2015-10-27 23:04:45

Search by substring in mysql full text in boolean mode?

Hello.
I got the project, and it has a query to the MyISAM table. A query is made with something like this:
match(data) against('test*' in boolean mode)
Therefore, as a result, there are all lines that begin with test. But how to do, using the
match(data) against('test*' in boolean mode) condition,
what would be returned lines in which test is in the middle of the line, for example brrrr test brrr (analogue of data LIKE "%test%")?
Thanks

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Max, 2015-10-27
@MaxDukov

no way.
dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html
The wildcarded word is considered as a prefix that must be present at the start of one or more words.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question