Hi,
I have been searching tables based on search values which turn up tobe fine,
however the results dont reflect case sensitivity.

what i mean,

if i run following query

select field1 from table1 where name='text1';

this works fine but returns the same result set with text1 values of 'USER'
or 'user'.

i need to run the query which should run case sensitive. ie USER is
different from user

Thanks in advance who can throw some ligth

Adamji





---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to