Search for column that contains more than 20 characters 1

[biglebowski]

We are having issues where transaction numbers are being inserted into the DB with more than the specified number of characters.

They should go into a column called transaction so what i want to search for is something like:

select * from Packages where Transaction contains more than 20 characters

 

[ChrisHunt]

select * from Packages where char_length(Transaction) > 20

On older versions of MySQL you might need to use length() instead of char_length() (the two functions are equivalent anyway if you don't need to deal with multi-byte characters)

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd