Professional Web Applications Themes

SQL SELECT, selecting data within a cell - PHP Development

I guess this is more sql than php, but there doesn't seem to be an appropiate sql ng, so anyway, I am trying to find the SQL command that does something like: $query = "SELECT filename FROM main WHERE keywords CONTAINS '$keywords' "; ie, I want it to return "filename" when the data in field "keywords" is eg "grass trees flowers" and someone searches with $keyword = "grass" but I can't find what to replace CONTAINS with. Any sugestions? cheers, mark....

  1. #1

    Default SQL SELECT, selecting data within a cell

    I guess this is more sql than php, but there doesn't seem to be an
    appropiate sql ng,
    so anyway,
    I am trying to find the SQL command that does something like:
    $query = "SELECT filename FROM main WHERE keywords CONTAINS '$keywords' ";
    ie, I want it to return "filename" when the data in field "keywords" is eg
    "grass trees flowers" and someone searches with $keyword = "grass"
    but I can't find what to replace CONTAINS with.
    Any sugestions?
    cheers, mark.



    Mark Guest

  2. #2

    Default Re: SQL SELECT, selecting data within a cell


    On 15-Aug-2003, "Mark" <markvanrossumNOSPAMyahoo.co.uk> wrote:
    > I am trying to find the SQL command that does something like:
    > $query = "SELECT filename FROM main WHERE keywords CONTAINS '$keywords' ";
    > ie, I want it to return "filename" when the data in field "keywords" is eg
    > "grass trees flowers" and someone searches with $keyword = "grass"
    > but I can't find what to replace CONTAINS with.
    > Any sugestions?
    > cheers, mark.
    select filename from main where keywords like '%grass%' ...

    if you have multiple keywords to search on use AND or OR e.g.
    select filename from man where keywords like '%grass%' and keywords like
    '%green%'

    --
    Tom Thackrey
    [url]www.creative-light.com[/url]
    Tom Thackrey Guest

Similar Threads

  1. Selecting certain data from Array
    By eric.mccalla in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: April 22nd, 04:44 AM
  2. Replies: 1
    Last Post: June 9th, 08:04 PM
  3. Getting to the data in a cell
    By Tim in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: April 30th, 11:23 PM
  4. Selecting item in listbox by data
    By FlashAsh99 in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: February 8th, 02:26 AM
  5. Selecting all columns, but in a different order in SELECT statement
    By Alex in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 12th, 07:38 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139