text count

[caaronbeasley]

Hello,

I am attempting to write a query that will count the number of times a word occurs in a text that I am entering into a database. I have successfully parsed the text that I want to enter into the database. My tables are as follows, (id, word, count). Thank you so much for all of your help.

[Merve]

Why do you need an SQL query to do this? Is there a reason you can't do it with PHP itself?

[caaronbeasley]

I am using a sql query to do this because the text file is very large, and I am going to ahve to do this for many texts.