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

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

MySQL colums by default are case-insensitive. If you want your column to be case-sensitive then you'll have to set it's type to BINARY or BLOB. For a workaround, however, try this:

http://www.mysql.com/...ivity_Operators.html

- wil

...and if SELECT BINARY fails, you better upgrade mysql pronto!!

Wow...you learn something new every day. Thanks for that Wil...I changed the field to a BLOB, rather than TEXT. Its all working like a charm now

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

It's amazing what a quick search at http://www.mysql.com yields. :-)

- wil