Can anybody tell me what is wrong with these mysql statements? I believe the LIKE is what is incorrect.

$Find_Query1 = mysql_query("SELECT * FROM pages WHERE title='$Search' AND keywords LIKE '$Search' AND description LIKE '$Search' ");
    $Find_Query2 = mysql_query("SELECT * FROM pages WHERE title LIKE '$Search' AND keywords LIKE '$Search' AND description LIKE '$Search' ");
    $Find_Query3 = mysql_query("SELECT * FROM pages WHERE title LIKE '$Search' AND keywords LIKE '$Search' ");
    $Find_Query4 = mysql_query("SELECT * FROM pages WHERE keywords LIKE '$Search' AND description LIKE '$Search' ");
    $Find_Query5 = mysql_query("SELECT * FROM pages WHERE keywords LIKE '$Search' ");
    $Find_Query6 = mysql_query("SELECT * FROM pages WHERE description LIKE '$Search' ");

Try this Joe.
Just find out the difference of the 3 query. ^^,

$Find_Query1 = mysql_query("SELECT * FROM pages WHERE title='$Search' AND keywords LIKE '%$Search%' AND description LIKE '%$Search%'"); // between
// or
$Find_Query1 = mysql_query("SELECT * FROM pages WHERE title='$Search' AND keywords LIKE '$Search%' AND description LIKE '$Search%'"); //starts with
// or
$Find_Query1 = mysql_query("SELECT * FROM pages WHERE title='$Search' AND keywords LIKE '%$Search' AND description LIKE '$%Search'"); //end with
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.