MySQL searching

[willl69]

Hi Guys

I have to do a very intensive and accurate database search using PHP nad
MySQL. I was wondering if anyone knew any good resources or where i could
get examples of good queries for a fulltext indexed database search.

Cheers

Willl

[News Me]

willl69 wrote:

Hi Guys

I have to do a very intensive and accurate database search using PHP nad
MySQL. I was wondering if anyone knew any good resources or where i could
get examples of good queries for a fulltext indexed database search.

Cheers

Willl

Here's one of my favorites:

SELECT
Artist.Name AS 'Artist',
Artist.AddThe AS 'ArtistAddThe',
Artist.RecId AS 'ArtistRecId',
Disc.Title AS 'Disc',
Disc.AddThe AS 'DiscAddThe',
Disc.RecId AS 'DiscRecId',
Track.Title AS 'Title',
Track.AddThe AS 'TrackAddThe',
Track.RecId AS 'TrackRecId',
Track.Number AS 'Track'
FROM Artist,
INNER JOIN Disc ON Disc.Artist=Artist.RecId
INNER JOIN Track ON Track.Disc=Disc.RecId
WHERE
Artist.Name LIKE '$search_artist'
AND
Disc.Title LIKE '$search_disc'
AND
Track.Title LIKE '$search_track'
ORDER BY
Artist,
Disc.Year,
Disc,
Track

[Rutger Claes]

willl69 wrote:

Hi Guys

I have to do a very intensive and accurate database search using PHP nad
MySQL. I was wondering if anyone knew any good resources or where i could
get examples of good queries for a fulltext indexed database search.

Cheers

Willl

The mysql online manual
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html

Rutger
--
Rutger Claes rg*@rgc.tld
Replace tld with top level domain of belgium to contact me pgp:0x3B7D6BD6
Do not reply to the from address. It's read by /dev/null and sa-learn only

[Ronald Chaplin]

willl69 wrote:

Hi Guys

I have to do a very intensive and accurate database search using PHP nad
MySQL. I was wondering if anyone knew any good resources or where i could
get examples of good queries for a fulltext indexed database search.

Cheers

Willl

Here you go.
http://www.analysisandsolutions.com/code/mybasic.htm
http://dev.mysql.com/doc/mysql/en/Tutorial.html
http://www.freewebmasterhelp.com/tutorials/phpmysql Part 1
http://www.freewebmasterhelp.com/tutorials/phpmysql/2 Part 2
http://www.createafreewebsite.net/ph...roduction.html

There's plenty more if you google for MySQL Tutorial.
HTH
--
Ron Chaplin
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
T73 Software & Design
www.t73-softdesign.com
To provide custom and quality
software, designs and services,
to our customers, at an affordable rate,
with minimal delay.