Full stops in Mysql queries?

[h_a_l_]

I am using Mysql to search for domains in a database.

For example:

SELECT COUNT(*) FROM domains WHERE domain = 'phpbuilder.com'

The problem is that the query will always return 0 whatever domain I input (that is present in the database). Unfortunately I built some more complicated parts of this script before testing the query itself so it took me a little while to figure out the problem was because of the full stop. If I remove the full stop in the database and use domaincom in the SQL query then the query works fine.

Anybody know how I can get this working with the full stop?

Many Thanks,

Hal

[h_a_l_]

Alright, it looks like I need to trim the data when importing it.
Pending resolution...