SQL - Query to find records that contain part of the value

Question

I have table zipcode which has a column called code. The Code column contains the prefix of zipcodes like

I want to write an SQL query that checks if the provided zipcode matches one of the values in the table. (Something like isValid)

I want to avoid writing all zip codes in the database.

Valid Input zipcode

Can anyone help me? Thanks

*I want to write sql query from* and why you do not do it? Where do you stuck — Jens, Mar 16 '22 at 10:01
@Jens i don't know how to write sql queries for this type of situation. — Pramod Tapaniya, Mar 16 '22 at 10:09
No there is lots of other too. Code that start with 395 453 302 1203 12 is valid — Pramod Tapaniya, Mar 16 '22 at 10:15
What have you tried so far? Where are you stuck? Do you want to write a raw SQL query, or one based on Laravels models? — Nico Haase, Mar 16 '22 at 10:19

score 1 · Accepted Answer · edited Mar 16 '22 at 10:17

1

simple sql query:

select * 
from zipcode 
where '395004' LIKE CONCAT(code,'%');

edited Mar 16 '22 at 10:17

VBoka

answered Mar 16 '22 at 10:09

Protap Singh

Thanks it worked, Just write answer in perfect format. – Pramod Tapaniya Mar 16 '22 at 10:15
As an alternative you can write the condition like: `where '%' + code LIKE '395004'` – Samy Sammour Mar 16 '22 at 10:19
@SamySammour no, it's not worked. – Pramod Tapaniya Mar 16 '22 at 10:22
@Protap Singh, can you write this in laravel format? – Pramod Tapaniya Mar 16 '22 at 10:36
@PramodTapaniya In laravel you have to use DB::Raw for concat. – Protap Singh Mar 16 '22 at 11:03
@PramodTapaniya what is the database engine? – Samy Sammour Mar 16 '22 at 13:16
@SamySammour MySQL – Pramod Tapaniya Mar 17 '22 at 06:03
Ok, it won't work! It is a valid SQL Server statement – Samy Sammour Mar 18 '22 at 08:10

1 Answers1