MYSQL wild cards?

Discussion in 'OT Technology' started by TRN, Jan 17, 2007.

  1. TRN

    TRN Well-Known Member

    Joined:
    Aug 22, 2003
    Messages:
    55,145
    Likes Received:
    135
    Location:
    North East
    Does anyone here know what the wild card is for a regular character?
     
  2. Slid.

    Slid. I'm a guy.

    Joined:
    Oct 25, 2001
    Messages:
    1,928
    Likes Received:
    0
    Location:
    NH
    % is for a LIKE statement


    bob
    boom
    bowl


    LIKE 'bo%' would return all of the above.

    If you want a single character I think you use _.
     

Share This Page