MySQL 8.0

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

CREATE TABLE IF NOT EXISTS botPatterns (
  `boltP` varchar(200) NOT NULL
)  ;

INSERT INTO `botPatterns` (`boltP`) VALUES
  ('6X135/6X139.7'),
  ('8X165.1'),
  ('8X165.1/8X170' ),
  ('8X170' );


CREATE TABLE IF NOT EXISTS Vehicles (
  `Brand` varchar(200) NOT NULL,
  `Pattern` varchar(200) NOT NULL
)  ;

INSERT INTO `Vehicles` (`Brand`,`Pattern`) VALUES
  ('Audi','6X135'),
  ('Audi','8X165.1'),
  ('BMW','8X170' ),
  ('Ford','9X139.7' );

Records: 4  Duplicates: 0  Warnings: 0



Records: 4  Duplicates: 0  Warnings: 0


SELECT *
FROM botPatterns
JOIN Vehicles ON LOCATE(Vehicles.Pattern, botPatterns.boltP)


boltP
Brand
Pattern


6X135/6X139.7
Audi
6X135

8X165.1/8X170
Audi
8X165.1

8X165.1
Audi
8X165.1

8X170
BMW
8X170

8X165.1/8X170
BMW
8X170


SELECT *
FROM botPatterns
JOIN Vehicles ON FIND_IN_SET(Vehicles.Pattern, REPLACE(botPatterns.boltP, '/', ','))


boltP
Brand
Pattern


6X135/6X139.7
Audi
6X135

8X165.1/8X170
Audi
8X165.1

8X165.1
Audi
8X165.1

8X170
BMW
8X170

8X165.1/8X170
BMW
8X170

boltP	Brand	Pattern
6X135/6X139.7	Audi	6X135
8X165.1/8X170	Audi	8X165.1
8X165.1	Audi	8X165.1
8X170	BMW	8X170
8X165.1/8X170	BMW	8X170