I ran into a weird behavior from Oracle this morning... And I can't understand why it acts this way from the docs. I'm sorry for the long post, but I want to make sure I'm understood. Oh, and make sure to read the note at the end before answering :) The goal of the request is to return rows with 1 or more lowercase characters. For the s...
I'm doing a presentation for Sr. Tech Managers and trying to figure out a quick overview of the tech differences of Google and FAST. Yes, I've googled, but nothing concrete (except marketing materials). ...
I have a small batch file to search and replace within a batch file. I am having difficulty removing things (eg replacing some text with a null value). Am sure it is simple but not found anything by searching! This is the file: Where you see xxxxx and yyyyy is where I need a blank! Cheers. @echo off setlocal enabledelayedexpansion ...
Trying to determine if there are any user folders on the network that don’t have an associated user account. All results return "Missing" when the majority should return "Found". Any ideas? $Dir = "\\ServerName\Share\" $FolderList = Get-ChildItem($Dir) | where {$_.psIsContainer -eq $true} $UserList = get-qaduser -sizelimit 0 | select Lo...
I'm using the sphinx search engine with the thinking sphinx plugin for rails. I have a job model with a title attribute that is indexed by sphinx. I'd like to search across multiple jobs and capture any that match 1 or more keywords. For instance... Job.search("rails, django, symfony") ...and get an array of job objects with the f...
I'm trying to create a search engine for all literature (books, articles, etc), music, and videos relating to a particular spiritual group. When a keyword is entered, I want to display a link to all the PDF articles where the keyword appears, and also all the music files and video files which are tagged with the keyword in question. The...
Kind of similar to how the "Related Questions" search works here when posting questions: What open source systems exists out there that lets your searches go beyond SQL based LIKE matches? I want to be able to query "he said it" and get results that includes "she said it" (with "said it" being the key, not the semantical meaning of he/sh...
Due to the wonders of branch prediction, a binary search can be slower than a linear search through an array of integers. On a typical desktop processor, how big does that array have to get before it would be better to use a binary search? Assume the structure will be used for many lookups. ...
I have a table that's holding metadata for entrys from another table. The metadata-table looks like this (I removed relating Ids so it's more obvious): id entry_id property value 1 12 color blue 2 12 shape circle 3 13 color red 4 13 shape circle 5 14 color blue 6 14 shape square 7 15 material stone 8 12 material plastic Now I w...
Digging around on youtube and flickr's APIs, I noticed Flickr allows you to poll all recent comments (once per hour). Youtube however only allows pulling all comments for a specific video. I'm curious if anyone has any clever ideas on a way to poll+cache or search site-wide youtube comments. I don't know what the comments per second r...
We have an email service that hosts close to 10000 domains such that we store the headers of messages in a SQL Server database. I need to implement an application that will search the message body for keywords. The messages are stored as files on a NAS storage system. As a proof of concept, I had implemented a SQL server based searc...
I have a fairly simple need to do a conditional update in Solr, which is easily accomplished in MySQL. For example, I have 100 documents with a unique field called <id> I am POSTing 10 documents, some of which may be duplicate <id>s, in which case Solr would update the existing records with the same <id>s I have a field called <dateCr...
For example, every time I post I question on stackoverflow.com, the UI suggest me plenty of similar questions. How is it functionality implemented? Are there some well-written algorithms about this? ...
I've got a MySQL table that acts like a nested set in order to contain a hierarchy of categories. The table schema looks like: CREATE TABLE IF NOT EXISTS `categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(200) NOT NULL, `parent_id` int(11) default NULL, `lft` int(11) default NULL, `rgt` int(11) default NULL, ...
I'm maintaining an existing website that wants a site search. I implemented the search using the YAHOO API. The problem is that the API is returning irrelevant results. For example, there is a sidebar with a list of places and if a user searches for "New York" the top results will be for pages that do not have "New York" in the main c...
In .Net 2.0, the WinForms ListBox and ComboBox controls allow you to search through the list by pressing the first letter of the list item on the keyboard. Subsequence presses of that key will cycle through the list items starting with that letter. A browser like FireFox on the other hand lets you "typeahead" search for items in a list...
Questions: How do you search for non-alphanumeric characters when using Google? Why doesn't Google always interpret strings enclosed within double-quotes literally? What is Google's escape character e.g. how would I search for something that contains a double-quote? Backgound: I am currently learning Grails. I was reading Masterin...
Hi, Does anybody know if it's possible to do a %LIKE% search against a column in a SQL Server database but get it to ignore any special characters in the column? So, for example if I have a column called "songs" and they contain the following... Black Or White No Sleep 'till Brooklyn The Ship Song Papa Don't Preach If the user...
Say,it just returns the snippet around which the searching keyword exists. And part of the text is replaced by "...". Is it possible to achieve that goal with PHP and MySQL? ...
Is there a way of keeping the index in RAM instead of keeping it on the hard disk? We want to make searching faster. ...