Jump to content

MYSQL Database Search


Lenton

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/191676-mysql-database-search/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.