如果ThreadPool已满，则如何使Action.BeginInvoke生成非线程池线程(If ThreadPool is full, how to make Action.BeginInvoke spawn a non threadpool thread)

 你正在寻找这个。 它可以为您提供所需的结果 
 
SELECT mycol, CONCAT('L.', mycol) AS newCol
 FROM(SELECT * FROM test WHERE mycol REGEXP 
'DATA_SOURCE_ID|LAST_MODIFIED_BY|LAST_MODIFIED_DATE|ATTRIBUTE[0-9]+') 
        as temp
 
 说明 
 
SELECT * FROM test WHERE mycol REGEXP 
    'DATA_SOURCE_ID|LAST_MODIFIED_BY|LAST_MODIFIED_DATE|ATTRIBUTE[0-9]+') 
 
 这将查找具有DATA_SOURCE_ID或LAST_MODIFIED_BY或LAST_MODIFIED_DATE或ATTRIBUTE后跟任何数字的所有行 
 
SELECT mycol, CONCAT('L.', mycol) AS newCol
 
 这会将L.添加到子查询找到的所有行。 
 
 OUTPUT 
 
L.DATA_SOURCE_ID,
L.LAST_MODIFIED_BY,
L.LAST_MODIFIED_DATE,
L.ATTRIBUTE13,
L.ATTRIBUTE14,
L.ATTRIBUTE15,
L.ATTRIBUTE16,
L.ATTRIBUTE17,
L.ATTRIBUTE18,
L.ATTRIBUTE19,
L.ATTRIBUTE20,
L.ATTRIBUTE21,
L.ATTRIBUTE22,
L.ATTRIBUTE23,
L.ATTRIBUTE24,
L.ATTRIBUTE25,
L.ATTRIBUTE26,
L.ATTRIBUTE27,
L.ATTRIBUTE28,
L.ATTRIBUTE29,
L.ATTRIBUTE30
 
 希望这可以帮助 

You are looking for this. It gives you your desired result
 
SELECT mycol, CONCAT('L.', mycol) AS newCol
 FROM(SELECT * FROM test WHERE mycol REGEXP 
'DATA_SOURCE_ID|LAST_MODIFIED_BY|LAST_MODIFIED_DATE|ATTRIBUTE[0-9]+') 
        as temp
 
EXPLANATION
 
SELECT * FROM test WHERE mycol REGEXP 
    'DATA_SOURCE_ID|LAST_MODIFIED_BY|LAST_MODIFIED_DATE|ATTRIBUTE[0-9]+') 
 
This finds all rows that either have DATA_SOURCE_ID or LAST_MODIFIED_BY or LAST_MODIFIED_DATE or ATTRIBUTE followed by any number
 
SELECT mycol, CONCAT('L.', mycol) AS newCol
 
This adds L. to all the rows that has been found by the subquery.
 
OUTPUT
 
L.DATA_SOURCE_ID,
L.LAST_MODIFIED_BY,
L.LAST_MODIFIED_DATE,
L.ATTRIBUTE13,
L.ATTRIBUTE14,
L.ATTRIBUTE15,
L.ATTRIBUTE16,
L.ATTRIBUTE17,
L.ATTRIBUTE18,
L.ATTRIBUTE19,
L.ATTRIBUTE20,
L.ATTRIBUTE21,
L.ATTRIBUTE22,
L.ATTRIBUTE23,
L.ATTRIBUTE24,
L.ATTRIBUTE25,
L.ATTRIBUTE26,
L.ATTRIBUTE27,
L.ATTRIBUTE28,
L.ATTRIBUTE29,
L.ATTRIBUTE30
 
Hope this helps