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]

Re: MySQL searching

willl69 wrote:[color=blue]
> 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
>[/color]

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=Art ist.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]

Re: MySQL searching

willl69 wrote:
[color=blue]
> 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[/color]

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

[Ronald Chaplin]

Re: MySQL searching

willl69 wrote:[color=blue]
> 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
>[/color]
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/phpmysql/phpmysql_introduction.html

There's plenty more if you google for MySQL Tutorial.
HTH
--
Ron Chaplin
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
T73 Software & Design

https://www.t73-softdesign.com

To provide custom and quality
software, designs and services,
to our customers, at an affordable rate,
with minimal delay.