Best unofficial Apache Server developers community |
Search
|
|||||||||||
|
Re: IN clause in search query to search a single field containing comma delimited values May 16, 2011 07:29:02 AM On 05/15/2011 09:14 AM, Igor Tandetnik wrote: > Pontiac<pont### @gmail.com> wrote: >> On 05/13/2011 03:15 PM, Trevor Borgmeier wrote: >>> SELECT categories FROM myTable WHERE (","||categories||",") LIKE "%,7,%"; >>… Re: IN clause in search query to search a single field containing comma delimited values May 13, 2011 02:22:14 PM On May 13, 2011, at 9:15 PM, Trevor Borgmeier wrote: > so if the "categories" field has a value of "1,8,15" Yep, it's a text column. Nothing relational about it. > Any advise would be appreciated. Normalize your design. Re: IN clause in search query to search a single field containing comma delimited values May 15, 2011 08:15:15 AM Pontiac <pont### @gmail.com> wrote: > On 05/13/2011 03:15 PM, Trevor Borgmeier wrote: >> SELECT categories FROM myTable WHERE (","||categories||",") LIKE "%,7,%"; > > Careful with how you have your like. As an added bonus,… Resolved: (CAMEL-1383) provide a text search - or a way to search by some expression for messages on September 19, 2010 04:45:08 AM [ https://issues.apache.org/activemq/browse/CAMEL-1383?page=com.atlassia n.jira.plugin.system.issuetabpanels:all-tabpanel ] Claus Ibsen resolved CAMEL-1383. Faceted search with MongoDB Vs Solr/Elastic Search Combo May 26, 2011 05:08:25 AM Hi, I need some advice regarding faceted search in MongoDB. I currently have around 100 milllion products in my collection. As you would expect faceted search is very important for the front end search implementation e.g.… indexed geo search slower than index-less naive search!?! November 21, 2010 08:43:40 AM I would like to do geo queries against a collection with 1M docs or more. I'm seeing terrible performance for geo queries, even though the outputs from find() commands and getIndexes() indicate that a 2d geo index is being used for the query. … Special characters search in elastic search December 8, 2010 11:55:21 PM Hi , Can any one explain how to search for special characters in elastic search? I am using standard analyzer for indexing and searching. For example in elastic search a field have a value @. if i search like… lucene search features in elastic search May 9, 2011 04:08:33 AM Hi, I've just discovered elastic search and it seems very nice. I used to use Lucene via Hibernate Search. I really like Lucene search capabilities , like approximation (Levenshtein distance) , phonetic search (Double Metaphone) or synonyms search.… Wildcard search issues in Riak Search December 15, 2010 09:41:15 PM I have put a few objects in the database, and the object looks like this: { "userid" : "jane", "first_name" : "Jane", "last_name" : "Doe", "gender" : "F", "joined_date" : "Wed, 15 Dec 2010 09:15:20 GMT" } I have 3 users whose id starts… Assigned: (FOR-1183) Forrestbar search of Jira issues broken, perhaps changed Jira search syntax January 5, 2011 11:59:31 AM [ https://issues.apache.org/jira/browse/FOR-1183?page=com.atlassian.jira .plugin.system.issuetabpanels:all-tabpanel ] Brian M Dube reassigned FOR-1183: Assigned: (FOR-1183) Forrestbar search of Jira issues broken, perhaps changed Jira search syntax September 23, 2010 01:48:20 AM [ https://issues.apache.org/jira/browse/FOR-1183?page=com.atlassian.jira .plugin.system.issuetabpanels:all-tabpanel ] Gavin reassigned FOR-1183: Closed: (FOR-1183) Forrestbar search of Jira issues broken, perhaps changed Jira search syntax January 12, 2011 08:15:31 PM [ https://issues.apache.org/jira/browse/FOR-1183?page=com.atlassian.jira .plugin.system.issuetabpanels:all-tabpanel ] David Crossley closed FOR-1183. riak search wildcard search May 2, 2011 03:48:26 AM Hi, I was trying out the wildcard search and i found out one interesting thing that the wildcard search doesn't work when i specify only one character. Is it a bug or is it some kind of protection mechanism to enforce faster output. Say if I do… Re: Search error when using JDBC for search (was "Metadata handling") August 13, 2010 11:11:20 AM This is now applied. Sorry for the delay. I'll slowly work through the rest of your patches today and tomorrow. Ethan On Sun, Aug 8, 2010 at 12:53 PM, <in.i### @gmail.com> wrote: > Yes. It will; there should be a Compass 'dialect',… Sorting Second Search Based on Sort of First Search (Sorting Path Feature) November 26, 2010 08:16:10 AM Hi Elasticsearchers, I was wondering if anyone encountered the issue above and what their experience was. Basically, say you have two related searches for two types of documents. Perhaps, the documents are sharded using the new routing feature… Re: Search error when using JDBC for search (was "Metadata handling") July 29, 2010 06:39:06 AM Ethan, Need to know - Re ESME-205, viz, Search is Broken.... Has this been implemented in the first place, with jndi/jdbc I mean...? And if it was, was it ever working ? Just getting into all the related stuff along with Lucene... Imtiaz … Re: Search error when using JDBC for search (was "Metadata handling") August 7, 2010 01:47:24 PM Sorry, I've been on vacation. I'm going to try to apply this in the next day or two, but if someone else can verify that it's working and apply the patch to trunk first, that would be great. Thanks, Ethan On Tue, Aug 3, 2010 at 12:12 PM, Imtiaz… Search error when using JDBC for search (was "Metadata handling") July 21, 2010 10:13:52 AM To recreate the problem, 1. Replace the contents of /src/main/resources/props/compass.cfg.xml with the contents of /src/main/resources/props/compass.jndi.cfg.xml 2. mvn jetty:run 3. Point your web browser to http://localhost:8080 4. Log in if… Re: Search error when using JDBC for search (was "Metadata handling") July 22, 2010 01:13:51 AM I mean, is this a compass thing ? but why is the exception name not printed in the log... ----- Original Message ----- From: "Imtiaz Ahmed H E" <in.imtiaz@gmail.com> To: <esme-dev@incubator.apache.org> Sent: Thursday, July 22, 2010… Elastic search creates 5 shards in default in Elastic search 0.14.0 December 29, 2010 12:18:56 AM Hi, I am indexing a doc with 1 shards and 0 replicas, but it creates 5 shards in default. Why its create like this ?. Another question here is where is the replica's stored? Twitter search: how do I include spaces before and after search string? (hint: %20 doesn't work!) February 26, 2011 I want to search tweets which contain a standalone string "$T", for instance: $T is doing well today! I can't wait to catch my flight with $T If $t… Postgres Query in Django Admin Search Hanging on Unicode Search May 2, 2011 I'm running a site that has both english and spanish translations for text. It's running django 1.2 and PostgreSQL 8.4.7. The database can store… C# regular expression search, format the search prase if boolean AND,OR,NOT presents April 21, 2011 hi, i need to do search engine, its like string matching, if the search string consists of boolean text like AND,OR,NOT i have to format the search… Resources : How to search for products whose price must be calculated on the fly based on the search criteria May 6, 2011 I'm planning an architecture for a price catalog/ selling system whose base produce cannot be stored in the database, but instead it must be… Sqlite/Core data or NSArray sort search results with relevent to search term. March 24, 2011 What I am looking for is showing relevant data than some random. Searching in the table give me results more like first come first shown... lets say… How to make a search functionality like the yahoo news site search May 2, 2011 hi how to create a search functionality like the the one in this page : http://news.maktoob.com/search?q=%D8%AE%D8%A8%D8%B1&type=site it searchs… Modifying simple search in rails to search linked data? January 13, 2011 I followed: http://railscasts.com/episodes/37-simple-search-form (albeit the updated version) to implement searching on my app. Right now when you… Python re.search (regex) to search words who have pattern like {{world}} only April 29, 2011 Hi All, I have on Html file in which i have inserted the custome tags like {{name}} , {{surname}} ,now i want to search the tags who exactly match… Convert vim / search to search and replace without retyping regular expression January 11, 2011 When I perform a search and replace in Vim, I like to use the search function ( /regex ) first to visually test my regex. Is there a simple way to… How to make keyword search more accurate with mysql search engine? May 28, 2011 Hello Guys, Ok so I created a search engine with mysql/php. I have a question. How do display the exact matched keyword url's first. For example If… How to make a search function? (Replace something with what people search for) June 3, 2011 This is my current code: $result = mysql_query("SELECT * FROM characters WHERE namn = 'Jargon'"); while($row = mysql_fetch_array($result)) { echo… Search multiple database fields using search bar in xcode February 18, 2011 I am developing an app that for our company that will allow our customers to pull up spec sheets and view brochures and such. I use a SQLite… MySQL: Best way to search in files' content (fulltext search) February 9, 2011 Hi! I'm currently developing a website which allows the users to upload presentations, documents and e-books (something like scribd and slideshare)… Tabbed search box with search suggestions in jQuery and PHP May 20, 2011 Hi I have a tabbed search box written in HTML and jQuery which decides where to send the users search based on the search type they have selected. I… Search for a line of text (as search criteria) and replace a ceratin string of digits in that line? (notepad++) March 8, 2011 I have a rather extensive autolisp file (roughly 4000 lines) that writes a big comma-delimited list of item numbers and their descriptions to a… Instant search with Whoosh - Index and search a MySQL table using Whoosh outputing JSON results June 18, 2011 I want to index a MySQL table using Whoosh and create an instant search page, so I need the results of the Whoosh search to be in JSON. Is there a… MySQL search based search March 29, 2011 In MySQL I have two tables, say Customers and Orders , looking like this: [Customers] 'ID' 'Name' 'Phone_nr' 1 Ted 12345 2 Anna 54321 3 Anna 98765… How to restrict Search page numbers on bottom of search result page-php? January 25, 2011 Hi, I am having problem in restricting search result page number in php page. I am using 3 fields to select user input and displaying search results… How to make "domain.com/search/q=query" from "domain.com/search/query" without breaking $_GET January 26, 2011 Hello! I've got: RewriteRule ^catalog/search/([a-zA-Z-_0-9]+)/(.*)/?$ index.php?page=catalog&type=search&category=$1&q=$2 [L]… Php search help December 21, 2010 following are my posted variables from search form: $city = $_REQUEST['city']; $location = $_REQUEST['location']; $bedrooms =… | |||||||||||
