How to convert column values to lower case and get data?

I have user nickname in my table in case insensitive type.

I tried to get a record from the table using this query but did not succeed:

$user = User::whereIn('LCASE(nickname)', strtolower($nickname));

Error message:

Invalid argument supplied for foreach()

How I can get users by nickname in case insensitive type?

asked Nov 22 '18 at 11:37

Andreas Hunter

740418

1

You missed ->first(), so your code would be $user = User::whereIn('LCASE(nickname)', strtolower($nickname))->first();. Or if you want to get a Collection you use ->get() instead of ->first()

– Julian Stark
Nov 22 '18 at 11:38

I tired ->first() and ->get() but error not changed. @DestinatioN

– Andreas Hunter
Nov 22 '18 at 11:41

1

Have you tried $user = User::whereIn('LCASE(nickname)', [strtolower($nickname)]);? whereIn expects an arrayable parameter. I'd suggest to change it to a normal where instead.

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:41

Sry i missed, that you use whereIn instead of where like @AdrianHernandez-Lopez answered

– Julian Stark
Nov 22 '18 at 11:44

When I try your code and ->first() return error message: Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users` where LCASE(nickname) in (otabek) limit 1)`

– Andreas Hunter
Nov 22 '18 at 11:44

add a comment |

I have user nickname in my table in case insensitive type.

I tried to get a record from the table using this query but did not succeed:

$user = User::whereIn('LCASE(nickname)', strtolower($nickname));

Error message:

Invalid argument supplied for foreach()

How I can get users by nickname in case insensitive type?

asked Nov 22 '18 at 11:37

Andreas Hunter

740418

1

You missed ->first(), so your code would be $user = User::whereIn('LCASE(nickname)', strtolower($nickname))->first();. Or if you want to get a Collection you use ->get() instead of ->first()

– Julian Stark
Nov 22 '18 at 11:38

I tired ->first() and ->get() but error not changed. @DestinatioN

– Andreas Hunter
Nov 22 '18 at 11:41

1

Have you tried $user = User::whereIn('LCASE(nickname)', [strtolower($nickname)]);? whereIn expects an arrayable parameter. I'd suggest to change it to a normal where instead.

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:41

Sry i missed, that you use whereIn instead of where like @AdrianHernandez-Lopez answered

– Julian Stark
Nov 22 '18 at 11:44

When I try your code and ->first() return error message: Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users` where LCASE(nickname) in (otabek) limit 1)`

– Andreas Hunter
Nov 22 '18 at 11:44

add a comment |

I have user nickname in my table in case insensitive type.

I tried to get a record from the table using this query but did not succeed:

$user = User::whereIn('LCASE(nickname)', strtolower($nickname));

Error message:

Invalid argument supplied for foreach()

How I can get users by nickname in case insensitive type?

asked Nov 22 '18 at 11:37

Andreas Hunter

740418

I have user nickname in my table in case insensitive type.

I tried to get a record from the table using this query but did not succeed:

$user = User::whereIn('LCASE(nickname)', strtolower($nickname));

Error message:

Invalid argument supplied for foreach()

How I can get users by nickname in case insensitive type?

laravel eloquent laravel-5.7

asked Nov 22 '18 at 11:37

Andreas Hunter

740418

asked Nov 22 '18 at 11:37

Andreas Hunter

740418

asked Nov 22 '18 at 11:37

Andreas Hunter

740418

asked Nov 22 '18 at 11:37

Andreas Hunter

740418

asked Nov 22 '18 at 11:37

Andreas Hunter

740418

1

You missed ->first(), so your code would be $user = User::whereIn('LCASE(nickname)', strtolower($nickname))->first();. Or if you want to get a Collection you use ->get() instead of ->first()

– Julian Stark
Nov 22 '18 at 11:38

I tired ->first() and ->get() but error not changed. @DestinatioN

– Andreas Hunter
Nov 22 '18 at 11:41

1

Have you tried $user = User::whereIn('LCASE(nickname)', [strtolower($nickname)]);? whereIn expects an arrayable parameter. I'd suggest to change it to a normal where instead.

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:41

Sry i missed, that you use whereIn instead of where like @AdrianHernandez-Lopez answered

– Julian Stark
Nov 22 '18 at 11:44

When I try your code and ->first() return error message: Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users` where LCASE(nickname) in (otabek) limit 1)`

– Andreas Hunter
Nov 22 '18 at 11:44

add a comment |

1

You missed ->first(), so your code would be $user = User::whereIn('LCASE(nickname)', strtolower($nickname))->first();. Or if you want to get a Collection you use ->get() instead of ->first()

– Julian Stark
Nov 22 '18 at 11:38

I tired ->first() and ->get() but error not changed. @DestinatioN

– Andreas Hunter
Nov 22 '18 at 11:41

1

Have you tried $user = User::whereIn('LCASE(nickname)', [strtolower($nickname)]);? whereIn expects an arrayable parameter. I'd suggest to change it to a normal where instead.

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:41

Sry i missed, that you use whereIn instead of where like @AdrianHernandez-Lopez answered

– Julian Stark
Nov 22 '18 at 11:44

When I try your code and ->first() return error message: Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users` where LCASE(nickname) in (otabek) limit 1)`

– Andreas Hunter
Nov 22 '18 at 11:44

You missed ->first(), so your code would be $user = User::whereIn('LCASE(nickname)', strtolower($nickname))->first();. Or if you want to get a Collection you use ->get() instead of ->first()

– Julian Stark
Nov 22 '18 at 11:38

I tired ->first() and ->get() but error not changed. @DestinatioN

– Andreas Hunter
Nov 22 '18 at 11:41

Have you tried $user = User::whereIn('LCASE(nickname)', [strtolower($nickname)]);? whereIn expects an arrayable parameter. I'd suggest to change it to a normal where instead.

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:41

Sry i missed, that you use whereIn instead of where like @AdrianHernandez-Lopez answered

– Julian Stark
Nov 22 '18 at 11:44

When I try your code and ->first() return error message: Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users` where LCASE(nickname) in (otabek) limit 1)`

– Andreas Hunter
Nov 22 '18 at 11:44

add a comment |

1 Answer
1

active

oldest

votes

WhereIn expects an array of values, in this case I'd suggest t change it to a base where (and add a first so you get the first value or use a get to return all users that matches).

$user = User::where('nickname', 'like', '%' . strtolower($nickname) . '%')->first();

edited Nov 22 '18 at 11:46

answered Nov 22 '18 at 11:43

Adrian Hernandez-Lopez

318113

Column not found: 1054 Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users where LCASE(nickname) = andreas limit 1)

– Andreas Hunter
Nov 22 '18 at 11:46

I have updated the answer to replace LCASE with the like operator

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:47

Updated work now for me, thanks @ Adrian Hernandez-Lopez

– Andreas Hunter
Nov 22 '18 at 11:48

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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53430130%2fhow-to-convert-column-values-to-lower-case-and-get-data%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

WhereIn expects an array of values, in this case I'd suggest t change it to a base where (and add a first so you get the first value or use a get to return all users that matches).

$user = User::where('nickname', 'like', '%' . strtolower($nickname) . '%')->first();

edited Nov 22 '18 at 11:46

answered Nov 22 '18 at 11:43

Adrian Hernandez-Lopez

318113

Column not found: 1054 Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users where LCASE(nickname) = andreas limit 1)

– Andreas Hunter
Nov 22 '18 at 11:46

I have updated the answer to replace LCASE with the like operator

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:47

Updated work now for me, thanks @ Adrian Hernandez-Lopez

– Andreas Hunter
Nov 22 '18 at 11:48

add a comment |

WhereIn expects an array of values, in this case I'd suggest t change it to a base where (and add a first so you get the first value or use a get to return all users that matches).

$user = User::where('nickname', 'like', '%' . strtolower($nickname) . '%')->first();

edited Nov 22 '18 at 11:46

answered Nov 22 '18 at 11:43

Adrian Hernandez-Lopez

318113

Column not found: 1054 Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users where LCASE(nickname) = andreas limit 1)

– Andreas Hunter
Nov 22 '18 at 11:46

I have updated the answer to replace LCASE with the like operator

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:47

Updated work now for me, thanks @ Adrian Hernandez-Lopez

– Andreas Hunter
Nov 22 '18 at 11:48

add a comment |

WhereIn expects an array of values, in this case I'd suggest t change it to a base where (and add a first so you get the first value or use a get to return all users that matches).

$user = User::where('nickname', 'like', '%' . strtolower($nickname) . '%')->first();

edited Nov 22 '18 at 11:46

answered Nov 22 '18 at 11:43

Adrian Hernandez-Lopez

318113

WhereIn expects an array of values, in this case I'd suggest t change it to a base where (and add a first so you get the first value or use a get to return all users that matches).

$user = User::where('nickname', 'like', '%' . strtolower($nickname) . '%')->first();

edited Nov 22 '18 at 11:46

answered Nov 22 '18 at 11:43

Adrian Hernandez-Lopez

318113

edited Nov 22 '18 at 11:46

answered Nov 22 '18 at 11:43

Adrian Hernandez-Lopez

318113

answered Nov 22 '18 at 11:43

Adrian Hernandez-Lopez

318113

answered Nov 22 '18 at 11:43

Adrian Hernandez-Lopez

318113

Column not found: 1054 Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users where LCASE(nickname) = andreas limit 1)

– Andreas Hunter
Nov 22 '18 at 11:46

I have updated the answer to replace LCASE with the like operator

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:47

Updated work now for me, thanks @ Adrian Hernandez-Lopez

– Andreas Hunter
Nov 22 '18 at 11:48

add a comment |

Column not found: 1054 Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users where LCASE(nickname) = andreas limit 1)

– Andreas Hunter
Nov 22 '18 at 11:46

I have updated the answer to replace LCASE with the like operator

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:47

Updated work now for me, thanks @ Adrian Hernandez-Lopez

– Andreas Hunter
Nov 22 '18 at 11:48

Column not found: 1054 Unknown column 'LCASE(nickname)' in 'where clause' (SQL: select * from users where LCASE(nickname) = andreas limit 1)

– Andreas Hunter
Nov 22 '18 at 11:46

I have updated the answer to replace LCASE with the like operator

– Adrian Hernandez-Lopez
Nov 22 '18 at 11:47

Updated work now for me, thanks @ Adrian Hernandez-Lopez

– Andreas Hunter
Nov 22 '18 at 11:48

add a comment |

draft saved

draft discarded

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.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Ytukyg