mysql - FullText search with additional where -


i'm having trouble working match against functionality of mysql. converted table , simple query like:

select * 'objectclient_objecten' match('dh_omschrijving) against ('these search words'); 

works! but.. want add other "where" elements. like:

select * 'objectclient_objecten' match('dh_omschrijving) against ('these search words') , `dh_status` = 1; 

but then.. no results. seems impossible add after using match. right? or there workaround?

try that

   select * 'objectclient_objecten' match(dh_omschrijving) against ('these search words') , `dh_status` = 1;                                                     ^^^^^^^^^^^^^^^^^---without quotes here 

match(here columns without quotes) , using column between quote.


Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -