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]

Reply via email to