Click here to get back home

distinguish between "-" and "_"
 Home | NewsGroups | Search | About
Login Password
Register Now!
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
distinguish between "-" and "_" leileili 05-21-2007
Get Chitika Premium
Posted by leileili on May 21, 2007, 5:29 pm
Please log in for more thread options
 Hello,

I encounter a problem when searching :

SELECT part_number, description FROM part WHERE part_number LIKE
"000-1_GB-01"

and

SELECT part_number, description FROM part WHERE part_number LIKE
"000-1-GB-01"

Both returns "000-1-GB-01". I expect to see the first search returns
"not found" since there's no"000-1_GB-01" in the database, only the
" . 000-1-GB-01".

Why it can't distinguish "-" and "_"? Does this related to
the setting in the database table ?

Thanks.

Lei



Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap