Professional Web Applications Themes

Search through ALL fields? - MySQL

Is there a way I can do a search that will return all rows that match a specific string in ANY of its fields? Something like "SELECT * FROM 'table' WHERE * LIKE 'keyword'" The second start is to denote ALL fields?...

  1. #1

    Default Search through ALL fields?

    Is there a way I can do a search that will return all rows that match a
    specific string in ANY of its fields?

    Something like

    "SELECT * FROM 'table' WHERE * LIKE 'keyword'"

    The second start is to denote ALL fields?
    Arash Guest

  2. #2

    Default Re: Search through ALL fields?

    Arash Barkhodaee wrote: 

    I meant "The second * is to denote ALL fields."

    Arash Guest

  3. #3

    Default Re: Search through ALL fields?

    Hi,
    I think that the best solution for you is to use the Full Text Search.
    With LIKE method the code becomes too complicated for the excessive use
    of OR and conditions concerning each field.




    Arash Barkhodaee ha scritto: 
    >
    > I meant "The second * is to denote ALL fields."
    >[/ref]
    Volare Guest

  4. #4

    Default Re: Search through ALL fields?

    Arash Barkhodaee wrote: [/ref]

    You probably have many columns that should be stored instead as rows in
    a dependent table. If you do that, then you don't need to search
    through many columns; you only need to search one column.

    SELECT * FROM `table1` AS t1 JOIN `table2` AS t2
    USING (`table1primaryKey`)
    WHERE t2.keywordColumn LIKE 'keyword';

    Regards,
    Bill K.
    Bill Guest

Similar Threads

  1. One Search String/Multiple Fields
    By KYMatt in forum Coldfusion Database Access
    Replies: 7
    Last Post: April 20th, 07:16 PM
  2. concat fields then search the new field
    By Darren Heinrich in forum ASP Database
    Replies: 4
    Last Post: February 6th, 02:28 PM
  3. Keyword search on 5 fields
    By ToniM in forum FileMaker
    Replies: 0
    Last Post: August 5th, 01:37 AM
  4. SQL Search Multiple Fields ??
    By Ulf Wendel in forum PHP Development
    Replies: 5
    Last Post: July 5th, 02:22 PM

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