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 - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188552
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
