Need help in using LIKE

[newphpcoder]

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

[guido2004]

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

[newphpcoder]

its not cloth id..

it cloth type

Thank you