Tony
You the man you spotted the problem great cheers. Now just gotta write a short perl script to get rid of them hell never knew invisible characters could be there.
I'm deffinately running the correct search parameter as i've tested it again and again with a load of different domains and it's only certain ones in a row of 10 records all together that don't work they are all in the same format.
I've got a feeling that Mysql is somehow missing them out when...
I do change the select each time to search for the one i want to search for.
select * from table where url<>'' works but that's not what i'm trying to do.
Why would a select function not find the record when it's there and I have the correct search parameter?
steve
All records have different domains
r937
Yep all the records show up when up I run that.
there's nothing much different on the domains just characters I can't understand why they don't show up when searching just for them.
Hi,
This problem is driving me crazy. I've got a table with about 200 records in it. It contains a list of domains.
When I do a select * from table it works shows all records. But when I do a select * from table where url="http://www.xxxxxx.com/blahblah" it shows most records but it doesn't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.