Great component. Absolutely a time saver when dealing with massive amounts of content/products.

I'm having a little trouble filtering, and I can't find any help on the "where" statement. Can you let me know what sort of operators I have access to when using where?

I found that where X_X != 0 worked, but I have tried LIKE "CONTENT" and not had it work.

Do you have any tutorial or help file for this?

Thanks!

You should be able to put any where statements in there that would also work in your normal mysql queries.
If you are trying to find fields that contains "CONTENT", you should do this:
X_X LIKE "%CONTENT%"
Without the % it is pretty much the sam as doing:
X_X = "CONTENT"

Thanks! Perfect!

One more question. I import a lot of items and that can leave columns as null. I've tried to search for those items. Is there any way to do a replace of that within the current DB Replacer?

Momentarily it isn't possible to replace NULL values...

Hi, this is a reply for the initial purpose of this thread about the WHERE filter.

I dont have any knowledge in DB statement and commands. I'm having a little problem understanding and applying the command presented in this thread.

I have a few questions... from an example:

As I understand it "TABLE","COLUMNS" and "WHERE" are filters. The latest needs to be adjusted in DB statement coding form.

I am looking for article titles that has the expression "guitar" in it.

From what I understand I should toggle "jos_content" in the first box, then "title" in the second box, but what statement should I put in the third box to look for the expression "guitar"?

Am I understanding this the wrong way?

Thanks a bunch,
Alex

try:

Great! It worked! Many thanks!

Alex