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
Post a Comment