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?
Try to change 'faus' to 'faus%'
Thanks, I will test it now.
What's code page you data field?
How can i see it?
Please check * inside %
Обсуждают сегодня