Laravel Take integer value from string from database while querying

Question

I have a field in database named experience and it has values like 5 Years or 2 Years etc. Now I want to search all users having experience between 2 years to 5 years. How can I do that? How can I apply a range on string like 2 years.

DB::table('experience')->whereBetween(what you want)->get(); you can try wherebetween — Siva Ganesh
– Siva Ganesh, Commented Mar 7, 2018 at 6:17

Siva Ganesh · Accepted Answer · 2018-03-07 06:21:27Z

1

you can try this

  DB::table('experience')->where(function ($query) use ($YOURVARIABLE) {
        $query->where('2years', '<=', $YOURVARIABLE);
        $query->where('5years', '>=', $YOURVARIABLE);
    })->get();

answered Mar 7, 2018 at 6:21

Siva Ganesh

1,4532 gold badges18 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Usman Iqbal Over a year ago

but please can you tell me how it happens that a string is dealing like integer on comparison operator?

Siva Ganesh Over a year ago

In the above case, I just checking an where condition using where condition it check the users between 2 to 5 years experience

Shoaib · Accepted Answer · 2018-03-07 07:27:11Z

0

first of all take all values from data with the years, store them in a array. than remove the the static 'Years' word from the string, you will get number, than apply range query on it. select * from YOURTABLE where YEAR_RANGE 'FIRST_VALUE' and 'SECOND_VALUE' order by YEARS desc;

answered Mar 7, 2018 at 7:27

Shoaib

35 bronze badges

1 Comment

Usman Iqbal Over a year ago

but dont you think it will make query slow?

Collectives™ on Stack Overflow

Laravel Take integer value from string from database while querying

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related