MySQL searching

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

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

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 rgc@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

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.