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

[abduraooft]

Sorry, your question isn't clear to me.

[Keleth]

Also your data looks identical (or near identical)... why do you need LIKE here?