[plug] mysql question

[James Devenish]

In message <Pine.LNX.4.44.0409241745541.14253-100000 at guild.murdoch.edu.au>
on Fri, Sep 24, 2004 at 05:46:19PM +0800, Shayne O'Neill wrote:
> no :( doesnt work either. I might have to make a big damn nest of LIKES
> and ors or something :(

The big cheater's way might be:

SELECT * FROM jobads WHERE
CONCAT(jobtitle,location,paytype,shortdescription,advertisement,contactdetails)
LIKE '%search text%';

(untested)