ive seen where churches have been spray painted ect and protests outside but if there was an actual shooting in one i havent heard about it or its at least VERY RARE.
I wouldn't call them common, but not rare either - I don't know why you haven't heard of any, when they happen they tend to be all over the news. Anyway, here's some that I found with a quick search that have happened over the past decade or so. I'm sure there are more, these are only those that qualified as "mass shootings", and only those in or at churches - if you include Christian schools, Jewish synagogues, and other places of worship the numbers increase noticeably:
March 5, 2023: Four people were injured in the parking lot of a Baptist church during a drive-by shooting in Shreveport, LA
October 28, 2022: Six people were shot by multiple assailants outside a church in the Brighton Heights neighborhood near Pittsburgh, PA during a funeral service
May 15, 2022: One person was fatally shot and five others were injured in a shooting at a church in Orange County, California.
February 28, 2022: A man fatally shot his three children and the children's chaperone, before shooting himself, at a church in Arden-Arcade, California
October 6, 2021: Two men were killed and two others wounded in a shooting in a church parking lot in New Orleans, LA
Nov. 5, 2017: Dressed in black tactical-style gear and armed with an assault weapon, 26-year-old Devin Kelley opened fire at the First Baptist Church of Sutherland Springs, Texas, killing 26 people and wounding about 20 others.
Sept 24, 2017: Emanuel Kidega Samson, 25, was charged with killing a woman and wounding six other people with gunshots at Burnette Chapel Church of Christ in Nashville, Tennessee.
Aug. 9, 2016: A shooting during a party at a Jersey City, New Jersey, church left 17-year-old Leander Williams dead and two teenage girls wounded. Daequan Jackson, 18, was charged with murder.
April 24, 2016: Mark Storms fatally shot 27-year-old Robert Braxton III during Sunday services in a suburban Philadelphia church. Storms, 46, argued self-defense, but was sentenced to 10 to 20 years in prison for voluntary manslaughter.
Feb. 28, 2016: Rev. William B. Schooler, 70, was fatally shot by his 68-year-old brother inside an office at St. Peter’s Missionary Baptist Church in Dayton, Ohio, as Sunday services were winding down. Daniel Schooler was found guilty of murder and sentenced to 31 years to life in prison.
June 17, 2015: Nine black worshippers including a pastor were killed by Dylann Roof, a 21-year-old white supremacist, after he prayed with them for nearly an hour. The shooting happened at historic Emanuel African Methodist Episcopal Church in downtown Charleston, South Carolina. Roof was convicted of federal hate-crime and obstruction-of-religion charges and sentenced to death.
March 31, 2013: A 28-year-old man fatally shot his father during Easter services at the Hiawatha Church of God in Christ in Ashtabula, Ohio. Reshad Riddle then made a rambling statement at the pulpit while yelling about God and Allah, still holding his handgun as panicked worshippers fled the church.
Dec. 2, 2012: Elementary school music teacher Gregory Eldred, 52, shot his ex-wife, Darlene Sitler, while she played the organ during a church service at the First United Presbyterian Church in Coudersport, Pennsylvania.
Oct. 24, 2012: A former facilities maintenance employee at World Changers Church International in College Park, Georgia, opened fire, killing church volunteer Greg McDowell, 39, while he was leading a prayer. Police arrested Floyd Palmer, 51, who was found guilty but mentally ill and sentenced to life in prison.
May 9, 2012: Joseph Lewis Jr., 84, was fatally shot while sitting in a car guarding Victory Way Assembly Church of God in Christ in Detroit, Michigan. Two teenagers, 15-year-old Anthony Williams and 18-year-old Alandre Boone, attacked him while a Bible study took place inside. Police suspected robbery was the motive. Both teenagers were tried and convicted as adults for second-degree murder.
May 3, 2012: A homeless man killed himself after fatally shooting a priest and a church secretary at St. Peter’s Episcopal Church in Ellicott City, Maryland. Police said Douglas Franklin Jones had been turned away from the church food bank about two weeks earlier for visiting every day instead of weekly.