MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Tab1 (wdt_id int, data varchar(10), results vARCHAR(20))
INSERT INTO Tab1
  (`wdt_id`, `data`, `results`)
VALUES
  ('1', 'abcd', 'Mazda'),
  ('2', 'abde', 'Toyota'),
  ('3', 'ace', 'Honda');
CREATE TABLE Tab2 (wdt_id int , selection varchar(20),selection_results varchar(20))
INSERT INTO Tab2
  (`wdt_id`, `selection`, `selection_results`)
VALUES
  ('1', 'abde', null),
  ('2', 'abcd', null),
  ('3', 'ab', null);
SELECT results FROM Tab1 WHERE EXISTS ( SELECT 1 FROM Tab2 WHERE selection LIKE CONCAT('%', Tab1.data , '%'))


results


Mazda

Toyota


UPDATE Tab2 SET `selection_results`  = (SELECT results FROM Tab1 WHERE  Tab2.selection LIKE CONCAT('%', Tab1.data , '%') ORDER BY wdt_id LIMIT 1)
SELECT * FROM Tab2


wdt_id
selection
selection_results


1
abde
Toyota

2
abcd
Mazda

3
ab
null