Jump to content

Need help with my query


Recommended Posts

Hi Mate,

 

i need help with my mysql query..

 

SELECT *
FROM `schedules`
WHERE `clientID`='';

 

it doesn't select any values having an empty clientID... there are rows on my database that i need to select that has an empty clientID and using this statement does not return any value... but if i use `clientID`!='' it works fine, it returns all the data having clientID.

 

Any help is highly appreciated.

 

Thank you in advance.

 

Neil

Link to post
Share on other sites

you will need to attach a partial sql dump of your database table as a file to a reply. this will show us the table definition, in case the definition of that column has something to do with the problem, and it will provide us with the actual data value you expect the query to match.

 

also, how do you know the query doesn't match the data? the method/code you are using to detect if there is a result set may be at fault.

Edited by mac_gyver
Link to post
Share on other sites
This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.