First thing is wind pushes the top few layers of the water column. This affect can pile up the phytoplankton, which results in baitfish fishing there and predators congregating there.
But the problem with this is you really need to know the underwater environment to know where the kelp, sand and rock structures are. Millenniums of prevailing current and wind have forged paths through the underwater world that food and fish travel along, when an opposing wind blows it can mess it all up meaning food does not make it to the fish and the water can get cloudy and weedier more than normal. To counteract this you will need to dive the area's you fish to see what will suit the area.... or just fish the days you know fish well for you.
To make it even worse!!
Different winds come from different directions. Our SW comes from the gulf stream which is also the prevailing current and combined they push warmth and food to our shores and encourage the fish to feed. S winds roll in from Africa over Spain and if they get to use (rarely) they just stirup the water. Easterly ain't so bad but NE and N are very cold coming down in a line from the poles usually when a band of low pressure appears and this can have a cooling effect on the water driving the thermoclines deeper which push the fish deeper or further out.
But sometimes a little wind from any direction is better than no wind and sometimes glass is best?
I'd update the oldwives tale to 'SW is best and NE fishes least'