homepage Welcome to WebmasterWorld Guest from 54.204.182.118
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Case insensitive conditional searches in MYSQL
case insensitive searches
Tourex

10+ Year Member



 
Msg#: 3863801 posted 8:35 pm on Mar 5, 2009 (gmt 0)

Can someone please enlighten this newbie.

I'm having a problem with a MYSQL select statement:

SELECT * FROM mydb WHERE Email = 'me@mydomain.com'

The problem is, the address is actually stored in the database Email column as "Me@MyDomain.com" and the search doesn't find it.

I thought string searches were case insensitive, but the failure of this search has proved that this is not the case. Can someone please help by explaining how I can do a case-insentive search on columns containing string values.

Thanks!

 

coopster

WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3863801 posted 8:52 pm on Mar 5, 2009 (gmt 0)

Depends on the column type amongst other things.
[dev.mysql.com...]

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved