search within query results

Anon

How can i search within the result of a mysql query?

Anon

Search for what?

Why not specify what you want to search in SQL statement?

Anon

i just want to query the result of a used query. For example: i searched my database for messages starting with 'hello'. Within the results i would like to search for messages which contain 'pieter'.
How can i do this?

Anon

once you get the query results in an array, write a for loop to go through each array result and do a str_search for 'hello'.

Anon

I think Allen's solution is probably right - but I'm not sure what you mean 'search within the result'.

You should provide more info.

Anon

I think Allen's solution is probably right - but I'm not sure what you mean 'search within the result'.

You should provide more info.

Anon

once you get the query results in an array, write a PHP for loop to go through each array result and use PHP ereg() pattern match for 'pieter'. But I believe you can do all this through a select statement as well. For speed and efficiency, I would try to get out as much as possible from the query first.

Anon

Okay this is how I would do it.

After running the query you would do something like this.

$result = @($query, $id);

$data = @mysql_fetch_array($result);

$rows = @mysql_num_rows($result);

//Remember arrays start at position 0

for ($i=0;$i<rows;$i++) {
@mysql_data_seek($result, $i);
$target=$data['fieldname'];
$pattern='(pieter)';
if (ereg($pattern,$target)){
//do whatever here
}
}

if you don't care about case, use egeri instead.

Anon

SQL Statement:

select * from SOME_TABLE where TEXT like 'hello%' and TEXT like '%pieter%'