Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Aug 2010
    Posts
    713
    Thanks
    165
    Thanked 0 Times in 0 Posts

    Need help in using LIKE

    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
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,852
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    Sorry, your question isn't clear to me.
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)

  • #3
    Senior Coder
    Join Date
    Jun 2008
    Location
    New Jersey
    Posts
    2,535
    Thanks
    45
    Thanked 259 Times in 256 Posts
    Also your data looks identical (or near identical)... why do you need LIKE here?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •