By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

MySQL searching

P: n/a
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

Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jul 17 '05 #2

P: n/a
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

Jul 17 '05 #3

P: n/a
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.
Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.