Using fulltext search on 'float'

[Zerpex]

Hi guys!

 

I'm trying out fulltext search in MySQL, when I do my query like this:

ALTER TABLE `products` ADD FULLTEXT(`name`, `breadcrumb`, `description`, `brand`, `price`, `year`, `km`, `usage`, `type`);

 

I get an error, that it can't add the FULLTEXT to price like this:

Column 'price' cannot be part of FULLTEXT index

 

Is it because I've set it to float, that I can't do it?

 

Best regards,

Lucas R.

[Muddy_Funster]

you can only apply a fulltext index to a field that can contain text....would have thought that was fairly self evident .  Moreove your should only be applying a fulltext index to long string fields that you are going to want to part-search, fields like name and type generaly gain no benefit from fultext indexing.  I suggest you research a little before "playing" with indexing.

[Zerpex]

you can only apply a fulltext index to a field that can contain text....would have thought that was fairly self evident .  Moreove your should only be applying a fulltext index to long string fields that you are going to want to part-search, fields like name and type generaly gain no benefit from fultext indexing.  I suggest you research a little before "playing" with indexing.

 

Hia Muddy,

 

the problem is, I need to be able to search, etc if I have a text input thingy, it should be able to search in columns, like name, price, brand, description, km, usage etc.

 

But I will try find a solution!

 

Thank you  alot!

[Muddy_Funster]

I'm sorry....whats a "text input thingy"?