MySQL NULL Value query Issue2019 Community Moderator ElectionHow can I prevent SQL injection in PHP?Which MySQL data type to use for storing boolean valuesHow to output MySQL query results in CSV format?How do I connect to a MySQL Database in Python?Should I use the datetime or timestamp data type in MySQL?Finding duplicate values in MySQLHow to get a list of MySQL user accountsRetrieving the last record in each group - MySQLHow to reset AUTO_INCREMENT in MySQL?How to import an SQL file using the command line in MySQL?
Is it necessary to separate DC power cables and data cables?
Rewrite the power sum in terms of convolution
Does "Until when" sound natural for native speakers?
Recommendation letter by significant other if you worked with them professionally?
How did Alan Turing break the enigma code using the hint given by the lady in the bar?
Sort with one element at the end
Is it possible to avoid unpacking when merging Association?
What are some noteworthy "mic-drop" moments in math?
Error during using callback start_page_number in lualatex
Hotkey (or other quick way) to insert a keyframe for only one component of a vector-valued property?
When a wind turbine does not produce enough electricity how does the power company compensate for the loss?
Intuition behind counterexample of Euler's sum of powers conjecture
Good for you! in Russian
What problems would a superhuman have whose skin is constantly hot?
Motivation for Zeta Function of an Algebraic Variety
What Happens when Passenger Refuses to Fly Boeing 737 Max?
Can you reject a postdoc offer after the PI has paid a large sum for flights/accommodation for your visit?
Marriage green card at end of current visa with 2 Year residency requirement waiver in-process, question
Linux Ubuntu 18.04 Full Backup
Do I really need to have a scientific explanation for my premise?
Accepted offer letter, position changed
Could you please stop shuffling the deck and play already?
Should I take out a loan for a friend to invest on my behalf?
What is the magic ball of every day?
MySQL NULL Value query Issue
2019 Community Moderator ElectionHow can I prevent SQL injection in PHP?Which MySQL data type to use for storing boolean valuesHow to output MySQL query results in CSV format?How do I connect to a MySQL Database in Python?Should I use the datetime or timestamp data type in MySQL?Finding duplicate values in MySQLHow to get a list of MySQL user accountsRetrieving the last record in each group - MySQLHow to reset AUTO_INCREMENT in MySQL?How to import an SQL file using the command line in MySQL?
Can any one guess what is teh issue in attached screen shot?
mysql
edited Mar 6 at 15:40
GiuServ
8381423
asked Mar 6 at 15:29
user2629839user2629839
149
|
show 4 more comments
Can any one guess what is teh issue in attached screen shot?
mysql
edited Mar 6 at 15:40
GiuServ
8381423
asked Mar 6 at 15:29
user2629839user2629839
149
Not me site cannot be reached. Best add to the question in some other way.
– P.Salmon
Mar 6 at 15:32
2
Please paste or retype the error message in your question. Also provide the steps or circumstances leading to the error. Apart from being rude to those who wish to help you, the external link does not load.
– Ilia Gilmijarow
Mar 6 at 15:33
can you click 2 hyper link for image
– user2629839
Mar 6 at 15:33
2
YouTRIMon the wrong side of=. And you have a line break in your data.
– Paul Spiegel
Mar 6 at 15:35
2
@user2629839 post the text, not links or images. Images can't be executed. Don't force people to try to read that image and retype the query when you can simply copy the text
– Panagiotis Kanavos
Mar 6 at 15:39
|
show 4 more comments
Can any one guess what is teh issue in attached screen shot?
mysql
edited Mar 6 at 15:40
GiuServ
8381423
asked Mar 6 at 15:29
user2629839user2629839
149
Can any one guess what is teh issue in attached screen shot?
mysql
mysql
edited Mar 6 at 15:40
GiuServ
8381423
asked Mar 6 at 15:29
user2629839user2629839
149
edited Mar 6 at 15:40
GiuServ
8381423
asked Mar 6 at 15:29
user2629839user2629839
149
edited Mar 6 at 15:40
GiuServ
8381423
edited Mar 6 at 15:40
GiuServ
8381423
edited Mar 6 at 15:40
GiuServ
8381423
8381423
asked Mar 6 at 15:29
user2629839user2629839
149
asked Mar 6 at 15:29
user2629839user2629839
149
asked Mar 6 at 15:29
user2629839user2629839
149
149
Not me site cannot be reached. Best add to the question in some other way.
– P.Salmon
Mar 6 at 15:32
2
Please paste or retype the error message in your question. Also provide the steps or circumstances leading to the error. Apart from being rude to those who wish to help you, the external link does not load.
– Ilia Gilmijarow
Mar 6 at 15:33
can you click 2 hyper link for image
– user2629839
Mar 6 at 15:33
2
YouTRIMon the wrong side of=. And you have a line break in your data.
– Paul Spiegel
Mar 6 at 15:35
2
@user2629839 post the text, not links or images. Images can't be executed. Don't force people to try to read that image and retype the query when you can simply copy the text
– Panagiotis Kanavos
Mar 6 at 15:39
|
show 4 more comments
Not me site cannot be reached. Best add to the question in some other way.
– P.Salmon
Mar 6 at 15:32
2
Please paste or retype the error message in your question. Also provide the steps or circumstances leading to the error. Apart from being rude to those who wish to help you, the external link does not load.
– Ilia Gilmijarow
Mar 6 at 15:33
can you click 2 hyper link for image
– user2629839
Mar 6 at 15:33
2
YouTRIMon the wrong side of=. And you have a line break in your data.
– Paul Spiegel
Mar 6 at 15:35
2
@user2629839 post the text, not links or images. Images can't be executed. Don't force people to try to read that image and retype the query when you can simply copy the text
– Panagiotis Kanavos
Mar 6 at 15:39
Not me site cannot be reached. Best add to the question in some other way.
– P.Salmon
Mar 6 at 15:32
Not me site cannot be reached. Best add to the question in some other way.
– P.Salmon
Mar 6 at 15:32
2
2
Please paste or retype the error message in your question. Also provide the steps or circumstances leading to the error. Apart from being rude to those who wish to help you, the external link does not load.
– Ilia Gilmijarow
Mar 6 at 15:33
Please paste or retype the error message in your question. Also provide the steps or circumstances leading to the error. Apart from being rude to those who wish to help you, the external link does not load.
– Ilia Gilmijarow
Mar 6 at 15:33
can you click 2 hyper link for image
– user2629839
Mar 6 at 15:33
can you click 2 hyper link for image
– user2629839
Mar 6 at 15:33
2
2
You
TRIM on the wrong side of =. And you have a line break in your data.– Paul Spiegel
Mar 6 at 15:35
You
TRIM on the wrong side of =. And you have a line break in your data.– Paul Spiegel
Mar 6 at 15:35
2
2
@user2629839 post the text, not links or images. Images can't be executed. Don't force people to try to read that image and retype the query when you can simply copy the text
– Panagiotis Kanavos
Mar 6 at 15:39
@user2629839 post the text, not links or images. Images can't be executed. Don't force people to try to read that image and retype the query when you can simply copy the text
– Panagiotis Kanavos
Mar 6 at 15:39
|
show 4 more comments
1 Answer
1
active
oldest
votes
Your first query works because you just used the LIKE clause with trailing %. For later case you just used the TRIM on the static text not on the value of your table column calledVs_Info. So you can try this way with TRIM()
SELECT Vs_Info FROM tbl_lb_dtls WHERE TRIM(Vs_Info) = 'shr-php-s-ame_eltkeynote-9185-vip';
answered Mar 6 at 15:57
Always SunnyAlways Sunny
16.7k32848
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55026673%2fmysql-null-value-query-issue%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Your first query works because you just used the LIKE clause with trailing %. For later case you just used the TRIM on the static text not on the value of your table column calledVs_Info. So you can try this way with TRIM()
SELECT Vs_Info FROM tbl_lb_dtls WHERE TRIM(Vs_Info) = 'shr-php-s-ame_eltkeynote-9185-vip';
answered Mar 6 at 15:57
Always SunnyAlways Sunny
16.7k32848
add a comment |
Your first query works because you just used the LIKE clause with trailing %. For later case you just used the TRIM on the static text not on the value of your table column calledVs_Info. So you can try this way with TRIM()
SELECT Vs_Info FROM tbl_lb_dtls WHERE TRIM(Vs_Info) = 'shr-php-s-ame_eltkeynote-9185-vip';
answered Mar 6 at 15:57
Always SunnyAlways Sunny
16.7k32848
add a comment |
Your first query works because you just used the LIKE clause with trailing %. For later case you just used the TRIM on the static text not on the value of your table column calledVs_Info. So you can try this way with TRIM()
SELECT Vs_Info FROM tbl_lb_dtls WHERE TRIM(Vs_Info) = 'shr-php-s-ame_eltkeynote-9185-vip';
answered Mar 6 at 15:57
Always SunnyAlways Sunny
16.7k32848
Your first query works because you just used the LIKE clause with trailing %. For later case you just used the TRIM on the static text not on the value of your table column calledVs_Info. So you can try this way with TRIM()
SELECT Vs_Info FROM tbl_lb_dtls WHERE TRIM(Vs_Info) = 'shr-php-s-ame_eltkeynote-9185-vip';
answered Mar 6 at 15:57
Always SunnyAlways Sunny
16.7k32848
answered Mar 6 at 15:57
Always SunnyAlways Sunny
16.7k32848
answered Mar 6 at 15:57
Always SunnyAlways Sunny
16.7k32848
answered Mar 6 at 15:57
Always SunnyAlways Sunny
16.7k32848
16.7k32848
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55026673%2fmysql-null-value-query-issue%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Not me site cannot be reached. Best add to the question in some other way.
– P.Salmon
Mar 6 at 15:32
2
Please paste or retype the error message in your question. Also provide the steps or circumstances leading to the error. Apart from being rude to those who wish to help you, the external link does not load.
– Ilia Gilmijarow
Mar 6 at 15:33
can you click 2 hyper link for image
– user2629839
Mar 6 at 15:33
2
You
TRIMon the wrong side of=. And you have a line break in your data.– Paul Spiegel
Mar 6 at 15:35
2
@user2629839 post the text, not links or images. Images can't be executed. Don't force people to try to read that image and retype the query when you can simply copy the text
– Panagiotis Kanavos
Mar 6 at 15:39