It is expected to be released worldwide on 24 September 2010 along with its dubbed versions: Robot in Hindi and Robo in Telugu. It is also slated to make the largest worldwide opening for an Indian film, upon release.Īfter meticulous filming and production for over two years, the film is currently undergoing post-production work. Produced by Kalanidhi Maran, it is known for being the most expensive Asian film ever made. Rahman working on background score and soundtrack. The film features SUPER STAR RAJINIKANTH and Aishwarya Rai in the lead roles with A. Welcome to the part 7 of the biggest ever movie from India releasing on 011010Įnthiran (Tamil: எந்திரன்) is a forthcoming Tamil science fiction film co-written and directed by S. How can we search for specific SCORE in a comma delimited text field in MYSQL that uses the exact word (not a fragment) to come up with an ORDERED list of results.Įvery attempt on this so far will still have Keyword List 3 show up higher than 2 even though red appleberry and red apple are two different phrases separated by commas.ENTHIRAN enum Boogambam - Advance Booking Arambam - v7.0 Instead of searching for 'red apple' search for 'red apple,'īut what if the user put a space between - or if its at the tail end of the list of keywords? Record 2 should show up and then Record 1 and not even show record 3. (It would be simplest if MySQL had some kind of 'explode' function that you could specify the comma (',') as the delimiter in the match but I don't know of any such method, do you? Of course you'd have to read the entire list of results into an array and then explode them in PHP.ģ) Suppose I search for 'red apple' and here's the bug: I'd still have a match on 'red appleberry' (record 3) - I don't want that. Keyword List 3 would show up even though the match was 'red appleberry' instead of 'red apple' Here's what the query ought to how it should be:ġ) if my query is 'apple' Keyword list 1 should show up firstĢ) if my query is 'red apple' then Keyword list 2 should show up First because the word 'red apple' is CLOSER to the FRONT of the keyword list - closer to the beginning of the string. What I'm looking for is do process most of the logic in the MYSQL instead of reading it into an array and processing it in PHP as others have suggested. The relevancy would be based on how many repetitions of the word 'apple' appeared in the keyword list (this is the age old reason why all the search engines chose to ignore keywords altogether) - do you see where I'm going with this? This is certainly heading in the right direction - however will it won't sort the results by an exact match being found as more relevant. Someone suggested using the Match Against instead SELECT *, MATCH(Keywords) AGAINST('apple') AS Score Supposing I was more detailed in my query, and chose 'red apple' it would still show a match, but I wouldn't necessarily get have KEYWORD LIST 1 be more relevant than 2 or 3. I'd have to do do the filtering of the results post query. This would bring up the records that contain the word 'apple' including the record above but it wouldn't necessarily give me any sequence of higher or lower. SELECT * where keywords like '%apple%' from table Let's say I want to run a query against the word 'apple' When I run a MYSQL SELECT query from what I've seen 'so far' there are two ways: a) like %% b) match against The keyword list is NOT an array - just a text field in a mysql database that has a lot of other fields. KEYWORD LIST 3: apple, red appleberry, flower KEYWORD LIST 2: cat,mouse,apple,red apple,flower,red appleberry I have a list of keywords in a field called 'keywords' in a MYSQL database For example the keywords field in the record contains 3 sample records KEYWORD LIST 1: tree,apple,banana,cherry,flower,red apple,pink cherry,cat,mouse
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |