TalkPHP - Match and Against

TalkPHP (http://www.talkphp.com/forums.php)

- General (http://www.talkphp.com/general/)

- - Match and Against (http://www.talkphp.com/general/4941-match-against.html)

russellharrower

09-12-2009 03:28 PM

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

russellharrower

09-13-2009 01:15 PM

Can any one help with this?

All times are GMT. The time now is 06:26 AM.