Skip

3 posts tagged with sql by arrowhead.
Displaying 1 through 3 of 3.

Tricky SQL for a simple function

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 by arrowhead on Nov 23, 2007 - 14 answers

Need SQL help to fetch data, with some tricky conditions

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 by arrowhead on Sep 3, 2007 - 10 answers

PHP/MySQL question on search / sort

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 by arrowhead on Mar 9, 2006 - 14 answers

Page: 1
Posts