Select problem

[Anon]

Hallo!
I have a mysql Table tsubscriber with a field email varchar(255)
I have created an index on this field.

The problem is that when i perform select on some emails which are in the table, mysql don' t find those emails.

I wonder where the problem can be

I make: SELECT * from tsubscriber WHERE email='[e-mail]'

The email [e-mail] is in the database but the query returns not row found.
Any Idea??????

[bastien]

show more code

bastien

[Anon]

Try this, there are probably other characters in the field:

SELECT * from tsubscriber WHERE email like '[e-mail]%'