Database search

[neroag]

Hi Guys

Im trying to find a way to search a whole mysql database for 1 word in the database, i assumed something like the following would work but it doesnt...

$query="SELECT * FROM database WHERE MATCH = '$searchword' ";

can anyone suggest a way that i can get it to work please

Many thanks everyone

[DoctorWho]

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Review the link.

Did you setup your Index to account for using the "MATCH"?

The Fields in question must be 'FULTEXT' as shown below.

mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)

And here is an example of using Match.

mysql> SELECT * FROM articles
-> WHERE MATCH (title,body) AGAINST ('database');

edit:

BTW- when it says MATCH(title,body) that means it's going to use those columns only to look for the MATCH. SO you will have add all the columns you need it to look in for the MATCH

[neroag]

Thanx but i just get an error using

mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)

what should title, body be ?. in my database i have like 20 fields so im not quite sure what they should be set to in the above

Thanx

[neroag]

Hi Guys
Ok ive set up a column named (Client) to FULLTEXT and i want to search it for $searchstring

but ..

$query="SELECT * FROM database WHERE MATCH (Client) AGAINST ('$searchstring')";

doesnt find any results despite the $searchsting being present in many rows of (Client)

Can anyone tell me whats wrong plz

Many thanx

[rincewind456]

neroag wrote:

$query="SELECT * FROM database WHERE MATCH (Client) AGAINST ('$searchstring')";

doesnt find any results despite the $searchsting being present in many rows of (Client)

$query="SELECT * FROM [I]table_name[/I] WHERE MATCH (Client) AGAINST ('$searchstring')";