How can I write this query with Active Records?

[eluser]TheFuzzy0ne[/eluser]
Doing that with the Active Record class will probably be impossible, since it's geared more towards simpler queries.

When you say you want to change the WHERE condition, do you simply mean the value, or the entire WHERE condition. In either case, query bindings will probably help: http://ellislab.com/codeigniter/user-gui...eries.html (bottom of the page).