hello i would like to take this query "select * from vidz where 'title' like '%test%' and videos like '%new%' "; instead i would like it to be a full text search query. am having problems combining the two searches into one fulltext query if it was one query i would just do it like so "SELECT * FROM vidz WHERE MATCH(title) Against ('test'); this one would return all title with word test in it or "SELECT * FROM vidz WHERE MATCH(videos) Against ('new'); this one would return all videos with word new in it But what i would like to do is get a result only if both are true. how can i get it all in one fulltext query any help would be very much appreciated Thanks
that query is ok but it doesn't search videos column the way am using this query is that its coming from a search filter, with radio buttons. so if two buttons are selected, lets say videos and title are selected then we search title for the query entered in the search bar and videos for new am not sure if this is at all possible with full text searching but if it is then that would be great