Thanks Maureen,
The == was the problem. I can search with upper and lower case and only
partial words.
Hosting is using 3.23.45 mysql so I don't believe that was the case.
Thanks again!
Jennifer
"Maureen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Here
Here is some more information I found in the manual about case sensitivity in
searches. The whole page is at
http://www.mysql.com/doc/C/a/Case_sensitivity.html
Here is the text that shows what might be the problem:
"In older MySQL versions LIKE comparisons where done on the uppercase value
o
Jennifer
I suggest you check out MySQLs full text indexing capabilities. If you
create a fulltext index on the text fields you want to search you can use
the MATCH function. This will perform a fuzzy matching search that returns
results in order of relevance. For details see
http://www.mysql.com/
Jennifer,
Check if there is a "set exact" setting for MySQL.
Using LIKE should find everything beginning with "Starr". You may also have
to convert search term and target values to one of lower or upper case in
the SELECT statement.
Miles
At 10:55 AM 4/25/2002 -0700, Jennifer Downey wrote:
>
I am quite positive that they are not Binary what I am finding is that it
has to be exactly as it is in the table.
I have one item called StarrRacing Guide if I put in starr or Starr it will
return nothing I have to spell it exactly like it is in the db "StarrRacing
Guide".
here is a dump of the t
The if/else/echo should all be within the while loop. The way it is now, it
should only show the last record returned, because that is the last value
within the while loop. The way you have it, the rest would be done after it
had looped through all of the records and it would return whatever