TalkPHP - View Single Post

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

09-12-2009, 03:28 PM	#1 (permalink)
russellharrower The Contributor Join Date: Jul 2009 Posts: 80 Thanks: 13	Match and Against 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