Search

[Anon]

Hi, me again

Is there a way to search with "%word%" in a whole table in mySQL instead of a particular column?

Thanks in advance
Chris

[Anon]

AFAIK, only by looping thru the number of columns and using or:

select * from yak where field1 like %whatever% or field2 like %whatever& or....

-Ben

Chris wrote:

Hi, me again

Is there a way to search with "%word%" in a whole table in mySQL instead of a particular column?

Thanks in advance
Chris

[Anon]

You can fudge it

SELECT * FROM table WHERE col1 like '%word%' OR col2 like '%word%' OR col3...

or this might work but I've never tried it

SELECT FROM table WHERE like '%word%'

Nath

[Anon]

Interesting idea - didn't work, though.

To do the "or" stuff, I'd write a code block
like this:

<?

$result="select * from table limit 1";

$result=pg_exec($connect, $result);

$row=pg_fetch_array($result, 0);

$sql="select * from table where ".$row[0]." like '%whatever%' ";

for ($i=1; $i<sizeof($row); $i++)
{
$sql=$sql." OR ".$row[$i]." like '%whatever%'";
}

$result=pg_exec($connect, $sql);

?>

-Ben

[Anon]

From the commands you use I assume your using postgresql, your code would work in mysql and, again, I assume the it will in postgresql although I've never used it.