How to update a mysql table with the count of another table while using like statement

While working on a web links directory i wanted to update categories table’s num_listings column with the count of listings under each category. The category id was stored something like this in listings table: Arvind KumarHello Friends, I’m Arvind Kumar,…

Read More