Find Queries Where Between First Letters Start with *

User::select(['id', 'names'])
    ->where('names', 'like', "a%")
    ->orWhere('names', 'like', "b%")
    ->orWhere('names', 'like', "c%")
    ->orWhere('names', 'like', "d%")
    ->orderBy('names')
    ->get();

Wait...is your list of names stored as a single column with comma separated names? I sure hope not...

Formulate your data correctly and use the greater than and less than symbols. Really there is nothing to this if you do it correctly.

could explain better @jlrdw ? do you think that have an easiest way than this ?

User::select(['id', 'names'])
    ->where('names', 'like', "a%")
    ->orWhere('names', 'like', "b%")
    ->orWhere('names', 'like', "c%")
    ->orWhere('names', 'like', "d%")
    ->orderBy('names')
    ->get();

becose imagine if I have to search from A to Z ...

If you have to search a-z, then really you're just getting all, it would just be User::orderBy('names')->get().

Maybe if you say what you're actually trying to do it would help. My answer was based on your question "and I want to GET all names between Letters -> A to D " lol.

All I meant is greater than A and less than D. It was just kind of a tricky question is all.

I would not hard code the letters, I would use variables. What if you needed greater than AP, just a thought.

You can also use regexp.

Db::select(SELECT id, names FROM users WHERE names REGEXP "^[A-D][a-z]+");