Hi,

i suggest you to use the LIKE operator instead of the relational operator.

Rui Cunha


Rosen writes:


Hi,
I have a simple table:


test (
id int unsigned NOT NULL auto_increment,
data varchar(30) default NULL,
PRIMARY KEY (id))


with two simple records:
id data
1 "a"
2 "A"


When I perform "select * from test where data='a' " - it return me both
rows.


By default in MySQL comparing of strings is case-insensitive.
How can I perform a case sensitive search in text fields ?


Tnanks in advance,
Rosen





*************************************
* Rui Pedro Cunha *
* Dpto. de Ciências e Tecnologias *
* Universidade Autónoma de Lisboa *
* Rua de Santa Marta, 56, *
* 1169-023 Lisboa *
* Telefone (+351) 21 317 76 35/49 *
* Fax (+351) 21 353 37 02 *
* Url : http://www.ual.pt/dct/ *
* E-mail: [EMAIL PROTECTED] *
*************************************


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to