SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: MySQL

  1. #1
    Bah, I'll just hack it DoobyWho's Avatar
    Join Date
    Jul 2002
    Posts
    476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL

    Whats the SQL to select all records that contain a certain word?

    Like if i wanted to return any record that contained the word "php" anywhere in the "description" field. Not if the field = "php" but if it contains it somewhere in it.

  2. #2
    Bah, I'll just hack it DoobyWho's Avatar
    Join Date
    Jul 2002
    Posts
    476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ?

  3. #3
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    You would have gotten better results if posted in the right forum...

    Anyway you want to do something like:

    Code:
    SELECT * FROM mytable WHERE description LIKE '%php%'
    Wayne Luke
    ------------



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
  •