SQL search, select query empty, blank field?

SQL search, select query empty, blank field?

It won’t work if you do search by “is null”.

Instead, you can go to the SQL tab and write something like:

SELECT * FROM `sqltable` WHERE 1 yourfield = ”

This will return all the entries which have “yourfield”, empty.

Replace “sqltable” with the name of your sql table.

Add a comment: