For zero solution you can also go to Jibberjabber Zero Solution page. You might find useful articles there.
PS: The problem was solved by changing the default value of the 'Find Utility' option to 'ExactMatch'
Q:
Custom MySQL query filter column, but don't keep a certain value
How can I filter MySQL table to keep the value of a column, but not its given datatype?
For example, if I want to keep the second column of the table as a int value but I don't want to keep the datatype as varchar, but in my case I have a text value I would like to keep.
SELECT * FROM TABLE
WHERE (column1) = 123
AND (`datatype` = 'varchar') // I don't want to keep this value
Thank you very much!
A:
The key is to use IS instead of =.
WHERE (column1) IS 123
AND (`datatype` = 'varchar')
Another solution is to use COALESCE instead of the equality operator =. COALESCE() returns the first non-NULL value of its arguments. So here, it will ignore the value for the datatype argument.
WHERE (column1) IS 123 AND COALESCE(`datatype`, NULL) = 'varchar'
UNPUBLISHED
UNITED STATES COURT OF APPEALS
FOR THE FOURTH CIRCUIT
No. 08-7632
DAVID ALVAREZ,
Petitioner - Appellant,
v.
WARDEN, Lee Correctional Institution,
Related links:
Comments