what like in MySQL?

Discussion in 'HTML & Website Design' started by techzarinfo, Jul 31, 2011.

0
  1. #1
    Hai Friends,

    How to call a name using like in MySQL? Please share your knowledge.

    Thanks & Regards
    TechZarInfo
     
    techzarinfo, Jul 31, 2011 IP
  2. JustAlex10

    JustAlex10 Member

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    41
    #2
    Can you post the table structure so I can help you?
     
    JustAlex10, Aug 3, 2011 IP
  3. dwirch

    dwirch Well-Known Member

    Messages:
    239
    Likes Received:
    12
    Best Answers:
    1
    Trophy Points:
    135
    #3
    Not sure what you are after, but the LIKE operator works the same as it does in MS SQL:

    SELECT * FROM MyTable WHERE Name LIKE '%John%'; 
     
    dwirch, Aug 4, 2011 IP
  4. Dale Rodgers

    Dale Rodgers Guest

    Messages:
    58
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Yeah as above, edit "MyTable" to the name of your table the fields are held in and edit "Name" to the name of the field the records held in.
     
    Dale Rodgers, Aug 4, 2011 IP
  5. omeslawanya

    omeslawanya Peon

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    post any exaple then I will help you.
     
    omeslawanya, Aug 18, 2011 IP