Please help me simplify a complicated mysql update [more inside]
posted by special-k on Mar 27, 2009 - 19 answers

Microsoft Access query problem - Comparing two similar tables that don't match up well. It's lists of classes in a collection of locations from two consecutive years, and what I need is to show the class fees side by side for any class that happened in the same location both years. [more inside]
posted by dnash on Feb 5, 2009 - 13 answers

I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
posted by maxwelton on Oct 15, 2008 - 8 answers

I've got what should be an uber-simple SQL question.... [more inside]
posted by omnipotentq on Jul 7, 2008 - 8 answers

I have an Access 2007 database with client information and I need to make it do two relatively simple tasks. [more inside]
posted by desjardins on Apr 11, 2008 - 6 answers

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted by Nothing on Mar 13, 2008 - 10 answers

SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted by Wild_Eep on Feb 21, 2008 - 6 answers

Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. [more inside]
posted by smithygreg on Nov 29, 2007 - 3 answers

Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted by odinsdream on Apr 18, 2007 - 9 answers

Databasefilter: I'm a self-taught 'DBA' (I use quotes so as to not offend those who have this knowledge through a paid education). I'm having an efficiency problem with a few of my tables, and I thought maybe one or two of you could help. [more inside]
posted by thanotopsis on Jan 31, 2007 - 20 answers

How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table? [more inside]
posted by apark on Jan 24, 2007 - 5 answers

Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted by Jimbob on Dec 13, 2006 - 3 answers

What is the easiest way to get this data into a MySQL database? [more inside]
posted by rlef98 on Nov 2, 2006 - 19 answers

I have a question about finding the longest sequence in a set of numbers. [more inside]
posted by maxwelton on Sep 2, 2006 - 13 answers

Filling Sparse Data In An SQL Query [more inside]
posted by boo_radley on Aug 7, 2006 - 5 answers

I need help converting a Postgres-specific SQL query to MySQL [more inside]
posted by mcstayinskool on Jul 14, 2006 - 14 answers

I'm looking for a software tool that will ingest a large XML file, and allow me to write sql-like queries against it for both summary reporting, as well as detailed reports. [more inside]
posted by nomisxid on Feb 15, 2006 - 31 answers

How do I write arbitrary SQL queries in Ruby on Rails? [more inside]
posted by smackfu on Dec 13, 2005 - 9 answers

I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted by Asparagirl on Nov 29, 2005 - 18 answers

I currently have a very low level of SQL knowledge (I can construct simple queries for multiple tables, but I start to fall apart on the difference between inner and outer joins). I need to learn to create multiple join SQL queries and Dynamic SQL/Stored Procedures on MS SQL Server 2000 in a short period of time. I'd also like to learn to use MS Query Analyzer more efficiently. Is there one book or online resource that is best for this? Additionally, are there alternatives to using MS Query Analyzer, or is that really *the* tool? [more inside]
posted by de void on Jul 12, 2005 - 12 answers

Say I have a database DATA.MDB
Inside DATA.MDB there is a table called ImageTable.
In this table is a field named fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all. [more inside]
posted by Grod on Apr 17, 2004 - 14 answers