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