SQL

[h2]About this SQL FAQ[/h2] CodeIgniter users [i]tend[/i] to use a SQL database for many of their projects. While there are a bunch of very good resources on the Intergoogle and in your local book store that describe how to use databases, the CI Forums are sometimes where people come first.

This page is where we should be able to point those people, and hopefully reduce the SQL noise in the forums.

[b][color=green]SQL FAQ : Table of Contents[/color][/b] [color=grey][i](Absent an automagic ToC feature in the CI-wiki, this is here for convenience only. Do NOT assume all the SQL FAQ's that are described here are also in this ToC (people are lazy and often forget to update the ToC when they add a section to the main page). So - please read through the whole page, and use Ctrl-F to to find key words, before posting to the forums.[/color]

[b]SELECT queries[/b]

• [i]How do I see the raw SQL query that AR is generating?[/i]
• [i]How do I do a COUNT('foo') using AR?[/i]
• [i]How do I emulate a [b]BETWEEN[/b] clause using AR?[/i]
• [i]placeholder[/i]

[b]INSERT queries[/b]%0