VARCHAR length should ony be of the needed number of characters to avoid very long indexes.

An index is also needed just on that column for fast indexed access avoiding full table scans.