In my SQL database some content in “posts” table has string like this:
Some Text.... <img src="sanad1.jpg?width=1198&trim=1,1&bg-color=000">...Some Text.
how can i remove anything after .jpg with a query?
Some Text.... <img src="sanad1.jpg">...Some Text.