1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Help with search engine-type thing

Discussion in 'PHP & Perl' started by †HøMø J£SüS†™, Jan 1, 2010.

  1. †HøMø J£SüS†™

    †HøMø J£SüS†™ Newbie

    Joined:
    Dec 17, 2009
    Messages:
    1
    Likes Received:
    0
    Well, basically what I am wondering, is what code would you use to check if something matches something in a column in a Mysql db. Such as: Lets say someone types "pie" the program runs through the DB and searches for the word "pie" and returns a certain value?
     
  2. alex1

    alex1 Junior Member

    Joined:
    May 23, 2009
    Messages:
    123
    Likes Received:
    110
    Occupation:
    Software Developer
    Location:
    Toronto, Canada
    select yourValueColumnName
    from yourTableName
    where textColumnName like '%pie%'
     
    • Thanks Thanks x 1