total values in row

Curlyc · #1 (**permalink**) 06-12-04, 11:02

Can I have a field in a mysql table that counts the occurances of a character "Y" or "y" in the record (row) and updates itself with each record update?

r937 · #2 (**permalink**) 06-12-04, 18:35

can you have a column that holds a count? sure, use INTEGER

can it update itself? no

Analyzer · #3 (**permalink**) 06-14-04, 10:52

Well, There is no need to have an automatic update field like this because every coder implements procedures to do this.

Analyzer

Curlyc · #4 (**permalink**) 06-14-04, 12:09

Any hints at how I can do it? I want to add a field to the table on this page...http://www.lakeside-graphics.com/beefs/avail3.php, that counts the Y's and y's.

Internet Services

Web Development

Digital Marketing

Consumer Tech