lofaifa Posted December 9, 2011 Share Posted December 9, 2011 i have this table under user_name='high' function_description : akram is in a date test akram is studying test4 kheith is male test3 i want a query that returns results of field that have at least an 'akram' SELECT * FROM functions WHERE 'isEnabled'=1 AND 'isPrivate'=1 AND user_name='high' AND function_description LIKE '%akram%' and this return abs NOTHING ! Why ? Quote Link to comment Share on other sites More sharing options...
fenway Posted December 9, 2011 Share Posted December 9, 2011 Because you're checking to see if the string 'isEnabled' is equal to the string '1' -- and it's not. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.