Record query under partial value conditions - SQL skill sharing

Question

I have a table called zipcode which has a column called code. The Code column contains the prefix of the zip code, for example 395453302120312 I want to write a SQL query that checks if the provided zipcode matches a certain value in the table. (Similar to isValid) I want to avoid writing all zip codes in the database. Valid entered zip code 39500439515239521256 Can anyone help me? Thanks

P粉442576165 · Answer

Simple SQL query:

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

Reference:SQL - Query if a string contains part of a column value