Hello. Can any one help me with FullTextSearch in MySqlDatabase

Question

Hello. Can any one help me with FullTextSearch in MySqlDatabase

in PHP?
I Have fulltext enable in table Accounts.
Now i want to select username column with fulltext search.

I use this query:
SELECT PName
FROM accounts
WHERE MATCH(PName) AGAINST('fuas');

it should return 3 columns:
fuas
fuas2
fuas3

but it just return:
fuas

Can any one help me?

0

18.12.2020

9 ответов

16 просмотров

Ibroh24

🤷‍♂

0

18.12.2020

Taha Автор вопроса

Ibroh24
SELECT pName FROM accounts WHERE pName LIKE %fu%

And how can I sort best match? for example i have this rows: [fuas12]0 [1fuas11] fuas fuas01 fuas1 it should sort this like this: fuas fuas1 fuas01 [fuas12]0 [1fuas11]

0

18.12.2020

Taha Автор вопроса

Taha
And how can I sort best match? for example i have...

Full text search should do this attomaticly, but I dont know how can I do that with LIKE query.

0

18.12.2020

Ibroh24

Taha
And how can I sort best match? for example i have...

I think the ORDER BY pName ASC will do that for you ie SELECT pName FROM accounts WHERE pName LIKE %fu% ORDER BY pName ASC

0

18.12.2020