Ok, its a little more complicated than the title, I think.

I want to update a column in one table with the number of times a different column in that table appears as a column in another table.

So,
Table1 = 'name, count'
Table2 = 'name, foo, bar, baz'

And I want count to equal the number of times the name of that column appears in table2.

Any help would be much appreciated, I'm still getting used to the whole concept of databases instead of programming.

Table2

name foo bar baz
--------------------------
test1 ghd lkw kdsks
test1 jw_1 hj3 gsks
test2 klsdf lasw jd


update table1 a set a.counted=(select count(*) from table2 b where b.name=a.name);

Table1

name counted
---------------
test1 2
test2 1