stevewaztech
Programmer
<img src= can I search for multiple keywords using a WHERE statement?</b><br><br>Here is a sample of my data. The column contains multiple values from an HTML form select box. <font color=red><br><FONT FACE=monospace> Name </font><FONT FACE=monospace> Languages </font></font><br><FONT FACE=monospace> Bob </font><FONT FACE=monospace> VBScript, Javascript, HTML </font><br><FONT FACE=monospace> Kim </font><FONT FACE=monospace> ASP, Cold Fusion, VisualIDev </font><br><FONT FACE=monospace> Jim </font><FONT FACE=monospace> Delphi, V++. C++, Clarion </font><br><br>When a user submits a query against this column, they are looking for multiple values (HTML AND / OR Javascript). I want to return rows that include any value that they search for. <br><br><b>Using a single where statement only returns rows that exactly match the search string </b><br>WHERE Languages = ‘HTML’ will only find a row that contains ‘HTML’<br>WHERE Languages Like ‘*HTML*’ will find all rows that contain the phrase ‘HTML’<br>But my users submit a search phrase like “HTML Javascript ASP’<br><br><b><font color=red>Is this the ONLY way to do it?</font></b><br>WHERE (Language Like '*HTML*' or Language Like '*Javascript*' or Language Like '*ASP*')<br><br>Similiarly:<br>WHERE (Language Like '*HTML*' and Language Like '*Javascript*' and Language Like '*ASP*')<br><br><br><br>If so, I can use javascript to build my WHERE statement, I was just wondering if there was an easier way to do it, aside from using the Full Text querying, and what is the limit length of a SELECT statement?<br><br><b>Thanks</b>