Will MySQL full-text-search return the results I need?

I have a keyword field with a list of 5 keywords for each item. example below:

2008, Honda, Accord, Used, Car

Will MySQL full text return the item above for the following search requests?

2008 Honda Accord
Honda Accord
Used Car 

If so, how 开发者_如何学Pythonwell will this hold up when searching through fifty thousand plus records?

You can use LIKE operator. WHERE x LIKE '%Honda%Accord%'. You get all rows contains HondaAccord*. I think is so helpful for your problem. Fifty thousand is small amout of records, you can not thinking about performance problem, you must only have index on this column.