mysql - 光标查找字数

Question

我正在尝试使用一个非常简单的游标来查找具有类似条件的表中的字数。我的光标是:

declare @Engword varchar(max)
Declare @wcount int

DECLARE word_cursor CURSOR FOR
select distinct engtitle from Table
where a1 = 'EHD'
ORDER BY Engtitle;

OPEN Word_cursor;

FETCH NEXT FROM Word_cursor
INTO @Engword;

WHILE @@FETCH_STATUS = 0  
BEGIN 
   Select @wcount = COUNT(*) from Table where engtitle like '%@Engword %'

   Insert into WordStatus(Engtitle,Estatus)
   Values(@Engword,@wcount)

   FETCH NEXT FROM Word_cursor
   INTO @Engword;
   end

CLOSE Word_cursor;
DEALLOCATE Word_cursor;
GO

我想插入每个单词及其计数，该计数来自不同表 WordStatus 中的类似条件。此游标正在新表中插入单词，但所有单词的计数都相同 0。请帮助!

Answer 1

这是因为引号字符串中不能包含变量 '%@Engword%' 无效。我认为如果您将该行更改为:

Select @wcount = COUNT(*) from Table where engtitle like concat('%', @Engword, '%')