MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


10.3.36-MariaDB-1:10.3.36+maria~deb10-log


CREATE TABLE article_keyword (
  `article_id` INT,
  `keyword_id` INT,
  `strength` INT
) COLLATE='utf8mb4_general_ci';

CREATE TABLE keyword (
  `keyword_id` INTEGER,
  `keyword` VARCHAR(10)
) COLLATE='utf8mb4_general_ci';

INSERT INTO keyword
  (`keyword_id`, `keyword`)
VALUES
  ('1', 'keyword1'),
  ('2', 'keyword2'),
  ('3', 'keyword3'),
  ('4', 'keyword4');

Records: 4  Duplicates: 0  Warnings: 0


INSERT INTO article_keyword (article_id, keyword_id, strength)
  WITH strength_table(strength, keyword) AS (
    VALUES (9, 'keyword1'), (11, 'keyword2'), (13, 'keyword4')
  )
  SELECT 100, keyword.keyword_id, strength_table.strength
  FROM keyword
  INNER JOIN strength_table AS strength_table
    ON strength_table.keyword=keyword.keyword

Records: 3  Duplicates: 0  Warnings: 0


select * from article_keyword


article_id
keyword_id
strength


100
1
9

100
2
11

100
4
13