SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Quick SQL help

  1. #1
    Free me php klassicd's Avatar
    Join Date
    Sep 2001
    Location
    San Diego
    Posts
    509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Quick SQL help

    I have a table named people. I have 2 rows named "name" and "description"

    I want to do a SQL query that will select the rows that contain a certain word in the "description" row.

    I just dont remember how to do a contain query. ANy help please?

  2. #2
    Grumpy Mole Man Skunk's Avatar
    Join Date
    Jan 2001
    Location
    Lawrence, Kansas
    Posts
    2,066
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    select * from table where description like '%word%'


Bookmarks

Posting Permissions

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