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?
[snip]
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'
[/snip]
http://www.mysql.com/select should do it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
[snip]
Tried that but no luck.
What I want is a search that will look for '15' (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 BO
.mysql.com
Subject: RE: Are partial searches possible?
Tried that but no luck.
What I want is a search that will look for '15' (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.
Con
d, 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?
ED]
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($fo
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 f