php/mysql query help

[paragouldgamer]

I was wondering if there was a contains word to use with a mysql query, my current query is :

//$query="SELECT * FROM $table WHERE date = '$selecteddate' AND Style = '$selectedstyle' AND Platform = '$selectedplatform'";

but the $selectedplatform isn't always the only thing in the Platform column, I just want to search the database to see if that column contains the value of $selectedplatform for the row in question.

[sergb]

Take a look at the LIKE search.
The following should select all records that have the word `John' in the `name' column.

SELECT * FROM client_names WHERE name LIKE '%John%';

[paragouldgamer]

OK thanks alot

[shekar.bdn]

select * from form where username='$username'&&password='$password';

[shekar.bdn]

$select=mysql_query("select * from form where username='$username'&&password='$password'");