Using MySQL 4.0.24 with PHP 4.3.11 I have the following code:
if($queryID = mysql_query("SELECT * FROM WhInventory WHERE Match(Booking) AGAINST ('" . mysql_escape_string($form['booking']) . "' IN BOOLEAN MODE) ORDER BY Booking",$dbLink)) { Which works fine if I have an exact entry but fails for a partial entry. For example. If I have an entry where "Booking" is 'TSIN150000' and I search on the string 'TSIN150000', it is found. How can I get it to find a partial match if the string I enter is only '150000' ? Thanks, Don -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]