Hi, I have one table column with multiple string separated by space. I can make it separated by comma if that helps the task. I would like to count the string occurrence in the table ex. there might be toyota, honda, ford... in the column. The number of string in that column varies. I would like to know how many toyota, how many honda, how many ford, how many anything .... in the whole table. I don't know what kind of string is in the column. It can be anything. I need to do it in php and mysql. Thanks for any help or tip in advance.
If, its a one time task, you can extract each row, split the string using the sstring delimiter, and then again put them in a new table, now you can do the operation using SQL commands on the table. If its a recurring process, its not recommended to do this as it will eat up lots of resources.