Are there SQL statements that return table names and field names for given table names in MySQL Server (5.0.22)? [more inside]
posted on Jul 7, 2008 - 8 answers

Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions. [more inside]
posted on May 4, 2008 - 12 answers

MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
posted on May 2, 2008 - 8 answers

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted on Apr 3, 2008 - 9 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 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 on Feb 21, 2008 - 6 answers

How does Facebook handle or simplify the presumably complicated DB queries involved so that me loading my page doesn't bring it to its knees? [more inside]
posted on Feb 4, 2008 - 27 answers

Been banging my head against the wall on this the whole day. I need a way to select & sort data from a single MySQL table, but it's a little bit more complicated that it seems. [more inside]
posted on Nov 23, 2007 - 14 answers

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted on Nov 15, 2007 - 7 answers

From two MySQL tables, I need to fetch a list of customers who DOES NOT have an invoice issued to them within the past 2 months. More details about the table structures inside. [more inside]
posted on Sep 3, 2007 - 10 answers

I'm trying to merge simple contact data from a bunch of single tables into one big text (csv) dump. The problem is that not all fields are present for each user. e.g. one user may be missing an email. Because of the missing field, my current (big and ugly) sql query will not return all the rows. [more inside]
posted on Aug 2, 2007 - 13 answers

Help with troublesome MySQL query? [more inside]
posted on Dec 6, 2006 - 8 answers

mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
posted on Dec 5, 2006 - 10 answers

Recommendations for a book to teach myself php and MySQL? [more inside]
posted on Nov 20, 2006 - 8 answers

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

MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
posted on Jul 19, 2006 - 12 answers

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

I'm writing a small app to store my contacts. There's a little tool to search for names. When I search for "Jo", the results should display all names starting with "jo", followed by those with "jo" in the middle: 1. Joanna 2. John 3. Jonathan 4. Marjorie 5. Mojo How do I do this using a single SQL statement?
posted on Mar 9, 2006 - 14 answers

What is the best alternative interface for an SQL server? [more inside]
posted on Jan 12, 2006 - 6 answers

I need to learn SQL, presumably mySQL. [more inside]
posted on Jan 4, 2006 - 22 answers

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

I have a MySQL database that contains two fields - name and e-mail - for a bunch of records. Separately I have a FileMaker 7 database that contains the same fields - name and e-mail - and contains other fields, like "notes". My question: can the FileMaker database, after polling the MySQL database, show name and e-mail as read-only; and then show the other fields as editable? i.e. if I make a change to the MySQL database, can I get it to show up in FM? [more inside]
posted on Sep 30, 2005 - 2 answers

myPHPadmin : I'm trying to get it to run an line of MySQL and it's complaining. Anyone got any thoughts? [MI]
posted on Nov 4, 2004 - 9 answers

mysqlfilter: I'm in the midst of installing phpwiki on OS X panther and, because I am following the steps drone-like and have no idea what I am doing. . .
posted on Sep 13, 2004 - 9 answers