complex subquery

BebeBlueEyez

Hi everyone.

I want a query to do this:

Query table for "$words" in column3

IF no results returned, break words up between " " into the var $wordsBrokenUp.

Query table for "$wordsBrokenUp" in column3

Find words in column and query results for identical column1

So... I was thinkina a subquery could do it all? Other then the break up the words part which I'm using:

$wordsBrokenUp = split(" ", $words);

Any help would be greatly appreaciated.😕

I am using PHP and MySQL

I have this so far:

$ONEQuery = "SELECT * FROM table where column3 LIKE '$words'";

$words = split(" ", $words);

foreach($words as $wordsBrokenUp) {
$Query = "SELECT * FROM table where column3 LIKE '$wordsBrokenUp'";

$subQ = "SELECT * FROM table where column1 = ???
}

Unfortunately I'm stuck.

nemonoman

$ONEQuery = "SELECT * FROM table where column3 LIKE '$words'";

ACTUAL QUERY will be more like this:

"SELECT * FROM table where column3 LIKE '%$words%'";

Note the %, these are the wildcard symbols

As for this:

$words = split(" ", $words);

foreach($words as $wordsBrokenUp) {
$Query = "SELECT * FROM table where column3 LIKE '$wordsBrokenUp'";

You'd really want to create from your long target a string that looks like:

"SELECT * FROM table where
column3 LIKE '%$word1%'
OR column3 LIKE '%$word2%'
OR column3 LIKE '%$word3%'
OR column3 LIKE '%$word4%'";

As for this query:
$subQ = "SELECT * FROM table where column1 = ???

I have no clue what you mean to do here?

Maybe:

"SELECT * FROM table where
column1 = ???
AND (column3 LIKE '%$word1%'
OR column3 LIKE '%$word2%'
OR column3 LIKE '%$word3%'
OR column3 LIKE '%$word4%'");

Is that what you mean?

BebeBlueEyez

Sort of...

See the querying that I'm doing, is part of a final query, and it really just makes up part of the where clause.

This is what i have:

//This is the string that was input
if(strlen($text)) {
     //This query checks to see if the entire sentance entered is found
     $AllQuery = "SELECT * FROM table WHERE column1 = '$text'";
     $AllResult = mysql_query($AllQuery) or die("Error ". mysql_errno() .":". mysql_error());
     //Now I break up the sentance into single words and explain why below
     foreach($text as $words) {
          $Query2 = "SELECT * FROM table WHERE column1 LIKE '%$words%'";
          $Result2 = mysql_query($Query2) or die("Error".mysql_errno() ." : ". mysql_error());
           if(mysql_num_rows($Result2) >0) {
                 //Now i'm lost
                 //Need to say that if it finds those words, it does another query to compare column2's, if it finds identical column 2's it returns those results... or puts them as part of the eventual where clause
     }
$where .- "$anyalllink (The query i come up with)";
}

Ok, so see, the database has a table, in this table documents have been stored in BLOBS, and it has been broken up into chunks if over a certain limit. I am going in, checking for the sentance, if it doesn't find the whole sentance (because perhaps it's been split up into the different chunks) it will then search the words. If it searches and finds words then it must check to see that the words belonging to the same ID (MasterID or index if you will) and therefore the chunks that make up the same document.

whoa boy is that more confusing or less?