MYSQL Database Search

[Lenton]

I currently use this MYSQL query in PHP:

mysql_query("SELECT * FROM test WHERE input = '$input'");

 

The problem with this is that you have to enter the exact input. For example if the input was 'red socks' if the user typed in 'socks red' it wouldn't find it.

 

I've explored various options like explode and wildcard but can't get any of them to work. Hope you can help me.

[sader]

 

mysql_query("SELECT * FROM test WHERE input = LIKE '%$input%'");

[Orionsbelter]

You need to learn about wildcards

[Lenton]

 

mysql_query("SELECT * FROM test WHERE input = LIKE '%$input%'");

 

Wouldn't that simply accept the string with anything before or after?