var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Making SQL Query by Using All Possible Combinations of Given Words
I have come across a challenge (for me at least) that I need to make an SQL Query by using all possible combinations of typed words to find the right records.
For example, the DB field contains the following:
HILTON WASHINGTON, 1919 CONN AVE., NW, DC., 20009
The user might search for:
hilton conn ave
hilton NW dc
I wanna to put all possible combinations into SQL query using 'OR' so that the user gets the right result.
Any idea how to implement this or any other good idea for the search criteria will be appreciated..
u can do this by procedure and make ur query dynamic.