mssql CONTAINTS返回无效行

Question

I have a mssql table like below:-

And mssql query from php page like below:-

SELECT * from tblstatusjadual where (idjadual LIKE '1%' AND 
CONTAINS(idjadual,'1.1 OR 1.2 OR 1.3 OR 1.4 OR 1.5 OR 1.6 OR 1.7 OR 1.8 OR 1.9'))
and tahun='2011'

As you can see, the CONTAINS bracket no 1.10 value, but when I run this query it return result with idjadual 1.10. Why this happen?

Any help very much appreciated.

Answer 1

Check out this example from MSDN

USE AdventureWorks2008R2;
GO
SELECT Name
FROM Production.Product
WHERE CONTAINS(Name, ' "Mountain" OR "Road" ')
GO

Based on this you might try something like this:

SELECT * 
from tblstatusjadual  
where (idjadual LIKE '1%' AND 
CONTAINS(idjadual,'"1.1" OR "1.2" OR "1.3" OR "1.4" OR "1.5" OR "1.6" OR "1.7" OR "1.8" OR "1.9"'))
and tahun='2011'