Search Mysql database with “LIKE” or “FULLTEXT”?

[divengrabber]

Hi,

I am working on the script that can search Mysql database.
To search Mysql database, I can use LIKE or FULLTEXT.
Could anyone tell me which one better? What is the major different?

Thanks!

[phaoloo]

for me, LIKE is better. It's a weird idea to get the exact data from database. You then can use PHP or any server script to process the result.

[alleghenyhealth]

I always use the Like operator. Seems to be easier to code with and understand what is going to be returned from the MySQL database.

[omfans]

I always use the Like operator. Seems to be easier to code with and understand what is going to be returned from the MySQL database.
A good tool. tks :D