Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
Out of curiosity, I've always wondered what is the least amount of information police can easily find someone if the know model, color and couple digits of license plate number.
Also depends on what numbers. Usually the first few numbers indicate the year the plates were issued (generally when the car was sold unless you need to get new plates. That's not very helpful if you have a new Toyota Camry in silver or conversely an old Toyota Camry with old plates from when it was first sold in silver. On the other hand if you have an old Camry with new plates, then it would be as they'll mostly have old plates.
Location: East of Seattle since 1992, 615' Elevation, Zone 8b - originally from SF Bay Area
44,553 posts, read 81,067,970 times
Reputation: 57712
It helps, but would take time since in many (larger) states there could hundreds or thousands of that same color, make and model containing those plate numbers.
You can do a simple search and find matching cars, and with a partial plate, model, model year range, etc. Yes it may be a lot in a state but you can narrow that down by city and by neighborhood depending on where the vehicle was seen. If you have partial information to report, just report it
Out of curiosity, I've always wondered what is the least amount of information police can easily find someone if the know model, color and couple digits of license plate number.
Does anyone know?
There is a command in SQL called "like". This command will allow you to search a database with a fuzzy command.
Here is the command:
Select lic_plate, owner, make, model from licplate_table
where
lic_plate like "xyz*";
You will list all of the plates in your state that start with xyz. Eyeball the list to find your make and model.
A couple of digits are not much to go on. Be sure that you are right.
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.
Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
The like command in SQL
