Need help in using LIKE

Databases
1

Hi…

I have 2 tables with Cloth column.

sales_order table
Cloth -column

sample data of Cloth

3392
3520
3392 Yellow/White
3392 BLUE
3392 RED
3392 Orange

cloth_parameter - table
Cloth -column

sample Cloth
3392N
3520
3392Yellow/White
3392 Blue
3392 Red
3392Orange

How can I equal the two data eventhough the format of data has difference using like.

Thank you

2

I guess I shouldn’t aks, but… why are you having different cloth ids in the orders table and the cloths table?

3

its not cloth id…

it cloth type

Thank you