I would do a sub-query where you union the same query on each column, and then query that.
|I have a db that contains 6 similar columns: line_1, line_2 , |line_3 , line_4 , line_5 , line_6 I want to have a search that |searches across columns. While I can search them |individually, it would be better if they were combined before |the LIKE was done so that if I had: |line_1="I need to" |line_2="go to the bathroom" |and I searched "need to go", it would return a hit. | |I'm not sure how to approach this but while I have a |beginning, I know that it is incorrect because it's the first |type of search, searching each line individually. | |<cfquery name="getSearchItem" datasource="dpch"> | SELECT |recipients_lname,recipients_fname,recipients_mi,leaf_number | FROM giving_leaves | WHERE line_1 LIKE '#s#' OR line_2 LIKE '#s#' |</cfquery> | |thanks for the help. | |-- |Daniel Kessler | |Department of Public and Community Health University of |Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 |301-405-2545 Phone |www.phi.umd.edu | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
