String contain alphabetic or not in query

Hello ,

I have one laravel query in which I have to get those record , which column data have not any alphabetic

	$getData = User::where('storeName', 'LIKE', '%name%')
    ->where('storeFile', 'LIKE', ???)
    ->get();

Here, 'storeFile' column have data which contain numeric as well as alphabetic. I want those record which have not contain alphabetic .

For example :

Then query should return 2 records (2,3).

Level 75

Try it with regex

$usres = User::where('storeName', 'LIKE', '%name%')
    ->whereRaw('storeFile REGEXP ^[0-9]+$')
    ->get();

Level 2

where('storeFile ', 'regexp', '^[0-9]+')

Level 75

It's exactly the same what I posted above.

Level 1

This not return valid output , this gives all record. not only record which have numeric

		$usres = User::where('storeName', 'LIKE', '%name%')
						->where('storeFile', 'REGEXP', '^[0-9]+$')
						->get();

Please or to participate in this conversation.