Match and Against

russellharrower · 09-12-2009, 03:28 PM

Hi guys having some small issue with Match and Against.

I need to allow users to search the following to rows in a table and if it matchs the first row (A) then it shows that result if it matchs (B) it needs to show that result.

So it needs to search row (A) first and then (B)

Code:

SELECT * FROM `tbl_fruit_ids` WHERE MATCH (A, B) AGAINST ('AAPL')

If you can help be great.

Thanks

russellharrower · 09-13-2009, 01:15 PM

Can any one help with this?