[SOLVED] Search multiple DB fields

[bigleo23]

I have a small problem that should be simple to fix, I am programming my site with dreamweaver since I don't know programming lang. yet. I am building a search results page and since I don't know php I am having trouble with the where statement, all I want is to search 5 0r 6 fields in the same table for the url variable. if someone could help me with what I am suppose to put in the where, in dreamweaver I would greatly appreciate it. Thank You

[toplay]

SELECT

          *

  FROM

          table_name

WHERE

                col1 = 'something'

          OR col2 = 'something'

          OR col3 = 'something'

          OR col4 = 'something'

          OR col5 = 'something'

 

 

MySQL select syntax page:

 

http://dev.mysql.com/doc/refman/5.0/en/select.html

 

[bigleo23]

I am truly sorry toplay, but could you explain a little bit more please?

[beebum]

With the "OR" only one of the columns needs to match the "something" in order to return the row. A returned row could have had a match on more than one column. Keep in mind that with the "=" it must be an exact match. Otherwise you must use "LIKE" instead of "=" or create a fulltext index across the columns.

[bigleo23]

OK so how do I set this up, I imagine I have to declare a variable for each of the fields that I want to search (col1 = 'something'). how would I set this up in dream weaver? The variable box asks for name default value and run time value?

[bigleo23]

I would like to thank everybody who helped me!!!!!

Hopefully I can help you out one day!!