mysql统计某个词在数据库中出现多少次

如果您要在整个数据库中搜索某个词并统计其出现次数，可以使用以下存储过程：

首先，创建一个名为`word_count`的存储过程：

CREATE PROCEDURE word_count(IN search_word VARCHAR(255))
BEGIN
  DECLARE table_name VARCHAR(255);
  DECLARE column_name VARCHAR(255);
  DECLARE done INT DEFAULT FALSE;
  DECLARE cur CURSOR FOR 
    SELECT CONCAT(table_schema, '.', table_name), column_name
    FROM information_schema.columns
    WHERE table_schema NOT IN ('information_schema', 'mysql', 'performance_schema')
      AND data_type IN ('text', 'char', 'varchar', 'longtext');
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
  CREATE TEMPORARY TABLE IF NOT EXISTS temp_word_count (word_count INT);
  TRUNCATE TABLE temp_word_count;
  OPEN cur;
  read_loop: LOOP
    FETCH cur INTO table_name, column_name;
    IF done THEN
      LEAVE read_loop;
    END IF;
    SET @search_query = CONCAT('SELECT SUM(CASE WHEN `', column_name, '` LIKE ''%', search_word, '%'' THEN 1 ELSE 0 END) AS word_count FROM `', table_name, '`');
    PREPARE stmt FROM @search_query;
    EXECUTE stmt;
    INSERT INTO temp_word_count SELECT word_count FROM (SELECT @word_count AS word_count) AS subquery;
    DEALLOCATE PREPARE stmt;
  END LOOP;
  CLOSE cur;
  SELECT SUM(word_count) AS total_word_count FROM temp_word_count;
END;

然后，您可以使用以下方式调用该存储过程：

CALL word_count('your_word');

在这个查询中，将`your_word`替换为要搜索的词。查询将返回一个名为`total_word_count`的列，其中包含您要查找的词在整个数据库中的出现次数。