Querying multiple columns.

Anon

Hi All,

I'm working on this job board system and having trouble with the search facility.

In a table each job listed one vacancy per row. There is about 25 columns in the row like: job description, job title, skills required, location, job id, ... I'm trying to make search that will search about in 8 columns. So far I have managed to search only from two columns. My query string:

SELECT * FROM jobs WHERE jobdesc OR position LIKE '%".$q."%' ORDER BY id_internal DESC

Attempts to add more columns ware unsuccessful.

Any ideas ?

Cheers
Max

Anon

You have to repeat the like predicate for each column.

SELECT * FROM jobs
WHERE jobdesc like '%".$q."%'
OR position LIKE '%".$q."%'
ORDER BY id_internal DESC

In your query the column position would be interpreted as a boolean value. (Most dbms handles booleans very sloppy or not at all.)

Anon

Hi Lars,

I'm using mysql late version, I was looking for information on boolean search could not find anything useful.

What exactly you mean by "repeat the like predicate"?

Thanks

Max

Anon

came up with query.

SELECT * FROM jobs WHERE jobdesc LIKE '%".$q."%' OR position LIKE '%".$q."%' OR id_internal LIKE '%".$q."%' ...... ORDER BY id_internal DESC";

Anon

Even this is possible:
SELECT * FROM jobs WHERE jobdesc LIKE '%$q%' OR position LIKE '%$q%' OR id_internal LIKE '%$q%' ...... ORDER BY id_internal DESC";

I think, the variable $q should be different for each Column. As each column contains different field value.