[SOLVED] IS NULL - Not an Option for phpMyAdmin search

[toxictoad]

Hi, I've got some fields in my database that are empty and using phpMyAdmin I wanted to use the search to pull these records out so I can update them all without having to find each one manually but I can't seem to find out how?

 

I tried using LIKE = IS NULL and other variations but they are empty fields and IS NULL doesn't return them. Is there a way around this, remaining in phpMyAdmin?

 

Thanks

[toxictoad]

can anyone help? if not with using the phpMyAdmin search, what about the sql that would pull these records? thanks

[Mchl]

UPDATE `table` SET `column` = 'Set your value here' WHERE `column` IS NULL

 

UPDATE `table` SET `column` = 'Set your value here' WHERE `column` = '' 

(for empty strings)

[toxictoad]

Thanks for the reply Mchl.

 

Where you say 'set your value here' what should this be? I tried leaving it blank but it doesn't return anything and yet I don't have a value to enter as the fields are blank?

[toxictoad]

I got it to work using

SELECT * FROM `mymovies` WHERE `plot` = ''

Thanks for your help

[Mchl]

The queries I posted, should update your empty fields with whatever you put instead of 'set your value here'

 

So if you want all empty fields to be for example '1' do

 

UPDATE `table` SET `column` = '1' WHERE `column` = '' 

 

Although from your example it seems that you will want to put different plot for each movie anyways

[toxictoad]

slowly getting an understanding of it (php/mysql) and after a little testing I could see what you'd given me, was just having trouble fitting it in with what I was doing but all good and I now know what I need to update records based using the SET & WHERE clause Thank you