I'm having a hard time implementing a search feature for a web based system I’m working on, I first use MySQL **Like** with **%wildcards%**, but it not searching what I want to display, then I come upon **Full Text index search**, it search very good but has an issue on displaying joined multiple tables with foreign key which I don’t know workarounds, then I came along with **MySQL with sphinx**, 

may I ask for any advice the best way/technologies to implement a **search** feature to search a Complex database tables