php - Full Text Search MySQL -

i know how use 'full text search mysql'. want know how search text words . exmaple :- have 3 records in mysql following

1.) place programmers .
2.) people visit places travelling purposes.
3.) programmers visit place site coding purposes.

now when user searches 'place programmers'

following should output

should output rows contain words sentence in order

1.)this place programmers.
2.)programmers visit place site for coding purposes.

thank helping .

mysql has match..against full text searches. try following,

select * <table> match(<column>) against('+place +for +programmers' in boolean mode)

the +'s mean , (you use - or)

UV code