MySQL query using REGEXP

My ISP uses MySQL 3.23.58 so I can't use FULLTEXT searches as I need results returned if more tha 50% of mydata set.

So I'm resorting to queries such as:

SELECT * from advert WHERE description REGEXP 'golf | gti';

Two questions:

1. How can I modify the REGEXP so that it searches for the words 'golf' AND 'gti' rather than 'golf' OR 'gti' ??

2. How can I modify the query so that it it searches through the fields description and title rather than just description (a tidy way as I need to search though about 7 different fields as it's a keyword search)

All help appreciated

Thanks

Hello Aaron, I believe all you would have to do is the following:

1. SELECT * FROM advert WHERE description REGEXP 'golf' AND description REGEXP 'gti';

I don't know if this is tidy enough, but you can keep adding AND qualifiers to the query string for each field. I have to admit, I'm quite new to SQL myself so there may be much better ways to do this:

2. SELECT * FROM advert WHERE description REGEXP 'golf' AND description REGEXP 'gti' AND field1 REGEXP 'exp1' AND fieldN REGEXP 'expN';

I should also mention I'm using MySQL 4.0.15 if that's relevant.

Hope this helps.