I had a weird thing happen today that I've never came across. I have a table full of data. I could not pull certain row and only that row
SELECT * FROM my_table where user = 'test'
I couldn't pull that row trying ANY of the the fields IE: address = 'whataever' city = 'mycity' etc.
Once i manually updated the row and re-enterd the data i could pull it.
repair table didn't help. I'm not sure what would cause this and would like to know