How do I use columns from a joined table in a match against clause in MySQL? -


i writing business directory , use mysql store data. have 3 tables use in scenario: listings, regions, , categories. listings have titles , descriptions. regions , categories both have titles. create search feature allow users combine keywords of listing titles , descriptions category , region titles. example, if searches string "cheesecake in pennsylvania" result cheesecake factory in philly. can match(columns) against(keywords)?

the mysql query below returning error incorrect arguments match

select     l.listing_id id, l.category_id, l.title listing_title, l.description, l.address, l.city, l.zip, unix_timestamp(l.date_submitted) date_submitted, l.latitude, l.longitude,     ( 6371 * acos( cos( radians(40.293861) ) * cos( radians( l.latitude) ) * cos( radians( l.longitude ) - radians(-76.600252) ) + sin( radians(40.293861) ) * sin( radians( l.latitude ) ) ) ) distance,     c.category_id cat_id, c.title cat_title, c.slug cat_slug,      r.region_id region_id, r.title region_title, r.slug region_slug  listings l left join categories c on l.category_id = c.category_id  left join regions r on l.region_id = r.region_id  match (l.title,l.description,l.city,r.title,c.title) against ('cheesecake in pennsylvania')

if remove r.title , c.title match columns works fine. here sqlfiddleto further demonstrate. open other ideas doing better way other using match.

i don't think so. columns named in match() must part of single fulltext index, can't define single fulltext index across multiple tables.

you may need combine 3 match() clauses or (like did in example here: http://sqlfiddle.com/#!9/89719/11).


Comments

Post a Comment

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

Image
i have script tag in code, keyboard shortcut comment/uncomment script tag in sublime. after selecting script open , close tag. <script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"> </script> i pressing ctrl + shift + / , getting this /*<script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"> </script>*/ also pressed ctrl + / , got this // <script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"> // </script> instead of <!-- <script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"> </script> --> script open , close tag in 2 lines not in 1 line , not have spaces too. for mac,high light lines want comment. hold 'command , / ' commented. for windows: high line or select lines ,then hold ctrl + / if not work: ...
Read more

post - imageshack API cURL -

i credentials correct. when send image through form this:(action="http://api.imageshack.com/v2/images/"). working fine when tried send $ch = curl_init($url); failed. code: enter code here <form action="" method="post" enctype="multipart/form-data"> select image upload: <input type="file" name="file" id="file" multiple> <input type="text" name="auth_token" id="auth_token" value="xxxxxxxxxxxxxxxx"> <input type="text" name="api_key" id="api_key" value="xxxxxxxxxxxxxxx"> <input type="submit" value="upload image" > </form> $url = ' http://api.imageshack.com/v2/images/ '; $temp = $_files["file"]['tmp_name']; echo $temp."<br>" ; $ch = curl_init($url); curl_setopt($ch, curlopt_post, true); curl...
Read more

dataset - MPAndroidchart returning no chart Data available -

i having problems mpandroidchart. adding temperature , humidity data chart, displays "no chart data available". here can see bug is? super grateful! //create data //set size of data int size = list.size(); if (size > 24){ size = 24;} //create lists form temp , hum arraylist<entry> temps = new arraylist<entry>(); arraylist<entry> hums = new arraylist<entry>(); //fill list temp values (int = 0; < size; i++){ entry value = new entry(math.round(list.get(list.size()-size + i).temp), (size-i)); temps.add(value); } //fill list hum values (int = 0; < size; i++){ entry value = new entry(math.round(list.get(list.size()-size + i).hum), (size-i)); hums.add(value); } ...
Read more