select * FROM docsearchprofile as dp Join docsearchaddress as da on da.`FK_DocSearchProfile` = dp.`ID_DocSearchProfile` and da.`Mode`='P' JOIN docsearchexperience as de on de.`FK_DocSearchProfile` = dp.`ID_DocSearchProfile` JOIN designation as d on d.id_designation = de.FK_Specialisation JOIN docsearchhospital as dh on dp.ID_DocSearchProfile = dh.FK_DocSearchProfile and dh.DefaultView=1 WHERE MATCH(dp.`Name`) AGAINST ('@name' IN BOOLEAN MODE) OR Match(d.`designation`) AGAINST ('@designation' IN BOOLEAN MODE) OR Match(dh.`HospitalName`) AGAINST ('@hospitalname' IN BOOLEAN MODE) OR MATCH(da.`HouseName`) AGAINST ('@housename' IN BOOLEAN MODE) OR match(da.`StreetName`) AGAINST('@streetname' IN BOOLEAN MODE)
@name='' @designation='+ENT*' @hospitalname='' @housename='' @streetname=''
1.Name:asdf Data:ENT 2.Name:zxcv Data:ENT
@name='+Z*' @designation='+ENT*' @hospitalname='' @housename='' @streetname=''
in last search the 2 outputs... But according to the input it will appear only the 2nd one in the 2nd result...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)