How to run a SQL query that searches for a part of the keyword in the database

Question

The keyword is automatically passed into the query. Suppose the keyword passed is 'Database Manager', now I want to display all results containing 'database'. i.e, it should query the first word of the two-letter keyword. Any help is much appreciated. Thanks. This is my query right now:

$jobQuerySqlStmt .= "
Select * 
  from job 
 WHERE specialization LIKE '$" . $this->paraValues[$std1->JOB_TABLE_SPECIALIZATION] . "%'";

I want the first word of $this->paraValues[$std1->JOB_TABLE_SPECIALIZATION] to be searched for, only.

You would need to split the string (if you just want the first word only). You should be able to do that via SQL or PHP. — Timothy G., May 10 '17 at 18:51
Possible duplicate of [SQL SELECT WHERE field contains words](http://stackoverflow.com/questions/14290857/sql-select-where-field-contains-words) — Ilyes, May 10 '17 at 18:52

score 0 · Answer 1 · answered May 10 '17 at 18:52

0

you might require to add % before and after the $ as below:

$jobQuerySqlStmt .= "
Select * 
 from job 
  WHERE specialization LIKE '%$%" . $this->paraValues[$std1->JOB_TABLE_SPECIALIZATION] . "%'";

answered May 10 '17 at 18:52

Kannan Kandasamy

13,405
3
25
38

That still searches for the exact keyword passed. I want to search for a part of the keyword that is passed. – Sidhant Chadha May 10 '17 at 18:56

score 0 · Answer 2 · answered May 10 '17 at 18:54

Sub 'Database Manager' with your variable that has the two word search term:

DECLARE @FirstWord NVARCHAR(MAX)
SET @FirstWord = SUBSTRING('Database Manager', 1, CHARINDEX(' ', 'Database 
Manager'))

Then you query will be like this:

Select * 
  from job 
 WHERE specialization LIKE @FirstWord + '%'

How to run a SQL query that searches for a part of the keyword in the database

2 Answers2