Gossamer Forum
Quote Reply
Case?
Is MySQL case sensative in its queries? I have;

SELECT * FROM `Advertisers` WHERE `Advertiser` = 'Andy'

But, for some reason it keeps picking up the user 'andy' (I have 3 users in the database, Andy, andy and someone)...I've never encountered this before....is it a MySQL thing, or something I need to do with my code?

Thanks

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread Case? Andy 8659 May 16, 2002, 6:57 AM
Thread Re: [Andy.] Case?
Wil 8228 May 16, 2002, 7:07 AM
Thread Re: [Wil] Case?
Andy 8249 May 16, 2002, 7:15 AM
Post Re: [Andy.] Case?
Wil 8196 May 16, 2002, 7:16 AM
Post Re: [Andy.] Case?
Paul 8223 May 16, 2002, 7:13 AM