Unique data getting

Feb 17 2018 4:18 AM
 
 
 
It is table structure, i want only get jobcategory 1 data
 
Query : 
SELECT NAME, JOBCATEGORY
FROM TABLENAME
WHERE (JOBCATEGORY LIKE '%1%')
 
result geeting jobcategory 12 also Only i want jobcategory = 1 data 
 
 

Answers (1)