[ACCEPTED]-MySQL - Fetch rows where a field value is less than 5 chars-sql

Accepted answer

Score: 33

For MySQL you would use the LENGTH() function 1 ie.

select * from users where length(zip_code) < 5

Refer to the docs at http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_length for more information.

Score: 12

CHAR_LENGTH(zip_code) < 5

0

Score: 2

You can use length

SELECT * FROM table WHERE LENGTH(myfield) < 5;

Check this out for more info.

0

Score: 2

If you are searching for bad zip codes then 7 char_length(zip_code) < 5 is a start, but it 6 will still pass invalid ZIP codes.

use SELECT 5 * from users where char_length(zip_code) < 5 4 OR zip_code NOT REGEXP '^([0-9]{5})$'

The 3 regexp part basically searches for zip_codes 2 where the first 5 characters are not numbers 1 between 0-9

Have Fun

Source: stackoverflow.com

More Related questions

Foreign keys in MySQL?

Should I add this new column to customers table or to a separate new table?

Converting date to this format

query " ALTER TABLE test_posts ADD sticky boolean NOT NULL default = false" = error

MySQL: Name primary key in CREATE TABLE statement

MySQL IN with LIKE

Change Data Capture in MySQL

Selecting all items in one table and join with another table, allowing nulls

My SQL Dynamic query execute and get ouput into a variable in stored procedure

how to find and replace a word in a mysql column?

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.