Maybe a good question to ask is where can I find documentation on: MySQL WHERE where_definition
Specifically, all the options available for the 'where_definition' -----Original Message----- From: Don [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 3:40 PM To: mysql@lists.mysql.com Subject: RE: Are partial searches possible? Tried that but no luck. What I want is a search that will look for '150000' (for example) in the field BOOKING. So if I enter '1' in my search field, it will find all instances of BOOKING with a '1' in it. Conversely, if I enter '12345' in my search field, it will find all instances of BOOKING with a '12345' in it. Hence, partial matches Thanks, Don -----Original Message----- From: Gordon Bruce [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 3:31 PM To: Don; mysql@lists.mysql.com Subject: RE: Are partial searches possible? You can try if($queryID = mysql_query("SELECT * FROM WhInventory WHERE Booking like ('%150000%') ORDER BY Booking",$dbLink)) -----Original Message----- From: Don [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 1:44 PM To: mysql@lists.mysql.com Subject: Are partial searches possible? 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
