You are looking for [`CHAR_LENGTH()`][1] to get the number of characters in a string. 

For multi-byte charsets [`LENGTH()`][2] will give you the number of bytes the string occupies, while `CHAR_LENGTH()` will return the number of characters.


  [1]: https://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_char-length
  [2]: https://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length

    SELECT * FROM table 
    ORDER BY LENGTH(column);

Documentation on the `LENGTH()` function, as well as all the other string functions, is available [here][1].


  [1]: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length

Having a look at [MySQL documentation][1] for the string functions, we can also use `CHAR_LENGTH()` and `CHARACTER_LENGTH()` as well.


  [1]: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

The function that I use to find the length of the string is `length`, used as follows:

    SELECT * FROM table ORDER BY length(column);

&gt; In my case I get data using mobile number length greater than 10 digits using the below query

    SELECT * FROM table_name WHERE CHAR_LENGTH(mobile) &gt; 10;

I used this sentences to filter 

    SELECT table.field1, table.field2 FROM table WHERE length(field) &gt; 10;

you can change 10 for other number that you want to filter.

    select * from *tablename* where 1 having length(*fieldname*)=*fieldlength*

Example if you want to select from customer the entry&#39;s with a name shorter then 2 chars.

    select * from customer where 1 **having length(name)&lt;2**

Is there a simple way to iterate over column name and value pairs?

My version of SQLAlchemy is 0.5.6

Here is the sample code where I tried using `dict(row)`:

    import sqlalchemy
    from sqlalchemy import *
    from sqlalchemy.ext.declarative import declarative_base
    from sqlalchemy.orm import sessionmaker
    
    print &quot;sqlalchemy version:&quot;,sqlalchemy.__version__ 
    
    engine = create_engine(&#39;sqlite:///:memory:&#39;, echo=False)
    metadata = MetaData()
    users_table = Table(&#39;users&#39;, metadata,
         Column(&#39;id&#39;, Integer, primary_key=True),
         Column(&#39;name&#39;, String),
    )
    metadata.create_all(engine) 
    
    class User(declarative_base()):
        __tablename__ = &#39;users&#39;
        
        id = Column(Integer, primary_key=True)
        name = Column(String)
        
        def __init__(self, name):
            self.name = name
    
    Session = sessionmaker(bind=engine)
    session = Session()
    
    user1 = User(&quot;anurag&quot;)
    session.add(user1)
    session.commit()
    
    # uncommenting next line throws exception &#39;TypeError: &#39;User&#39; object is not iterable&#39;
    #print dict(user1)
    # this one also throws &#39;TypeError: &#39;User&#39; object is not iterable&#39;
    for u in session.query(User).all():
        print dict(u)

Running this code on my system outputs:

    Traceback (most recent call last):
      File &quot;untitled-1.py&quot;, line 37, in &lt;module&gt;
        print dict(u)
    TypeError: &#39;User&#39; object is not iterable



How to convert SQLAlchemy row object to a Python dict?

What is the type for a BOOL value in SQLite? I want to store in my table TRUE/FALSE values.

I could create a column of INTEGER and store in it values 0 or 1, but it won&#39;t be the best way to implement BOOL type.

Is there a way?


Store boolean value in SQLite

    SELECT * FROM table ORDER BY string_length(column);

Is there a MySQL function to do this (of course instead of `string_length`)?



MySQL - How to select data by string length

<pre><code class="hljs language-sql">SELECT * FROM table ORDER BY string_length(column);
</code></pre>
Is there a MySQL function to do this (of course instead of <code>string_length</code>)?

I need to insert a long row with 32 fields into a MySQL table.

I&#39;d like to do something like this:

    $sql=&quot;insert into tblname values (... 32 fields ...)&quot;;

Obviously it works fine if the fields are in the same order as the MySQL table fields. But, my table has an auto-increment id as it&#39;s first field.

What I want is to fill in all table names but the first (id) one.

Suggestions?

PHP MYSQL - Insert into without using column names but with autoincrement field

I&#39;m looking for a way to update just a portion of a string via MySQL query.  

For example, if I have 10 records all containing &#39;string&#39; as part of the field value (i.e., &#39;something/string&#39;, &#39;something/stringlookhere&#39;, &#39;something/string/etcetera&#39;, is there a way to change &#39;string&#39; to &#39;anothervalue&#39; for each row via one query, so that the result is &#39;something/anothervalue&#39;, &#39;something/anothervaluelookhere&#39;, &#39;something/string/etcetera&#39;, is there a way to change &#39;anothervalue&#39;

MySql - Way to update portion of a string?

I have a huge table and I need to process all rows in it. I&#39;m always getting this Lost connection message and I&#39;m not able to reconnect and restore the cursor to the last position it was. This is basically the code I have here:

    #
    import MySQLdb

    class DB:
      conn = None
    
      def connect(self):
        self.conn = MySQLdb.connect(&#39;hostname&#39;, &#39;user&#39;, &#39;*****&#39;, &#39;some_table&#39;, cursorclass=MySQLdb.cursors.SSCursor)
    
      def query(self, sql):
        try:
         cursor = self.conn.cursor()
         cursor.execute(sql)
       except (AttributeError, MySQLdb.OperationalError):
         self.connect()
         cursor = self.conn.cursor()
         cursor.execute(sql)
       return cursor
    #

    #
    db = DB()
    sql = &quot;SELECT bla FROM foo&quot;
    data = db.query(sql)

    for row in data:
        do_something(row)
    #

But I&#39;m always getting this:

    #
    Traceback (most recent call last):
      File &quot;teste.py&quot;, line 124, in &lt;module&gt;
       run()
     File &quot;teste.py&quot;, line 109, in run
       for row in data:
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 417, in next
       row = self.fetchone()
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 388, in fetchone
       r = self._fetch_row(1)
     File &quot;/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py&quot;, line 285, in _fetch_row
       return self._result.fetch_row(size, self._fetch_type)
       _mysql_exceptions.OperationalError: (2013, &#39;Lost connection to MySQL server during query&#39;)
        Exception _mysql_exceptions.OperationalError: (2013, &#39;Lost connection to MySQL server during query&#39;) in &lt;bound method SSCursor.__del__ of &lt;MySQLdb.cursors.SSCursor object at 0x7f7e3c8da410&gt;&gt; ignored
    #

Do you have any idea?

Lost connection to MySQL server during query

What&#39;s the difference between VARCHAR and CHAR in MySQL?

I am trying to store MD5 hashes.

What&#39;s the difference between VARCHAR and CHAR?

Is it posible to duplicate an entire MySQL database on a linux server?

I know I can use export and import but the original database is &gt;25MB so that&#39;s not ideal.

Is it possible using mysqldump or by directly duplicates the database files?

Duplicate Entire MySQL Database

I can do SELECT TOP (200) ... but why not BOTTOM (200)?

Well not to get into philosophy what I mean is, how can I do the equivalent of TOP (200) but in reverse (from the bottom, like you&#39;d expect BOTTOM to do...)?

How to select bottom most rows?

Does the default `READ COMMITTED` *isolation level* somehow makes the `SELECT` statement act different inside of a *transaction* than one that is not in a transaction?

I am using [MS SQL][1].


  [1]: https://en.wikipedia.org/wiki/Microsoft_SQL_Server

Is there a difference between a SELECT statement inside a transaction and one that is outside of it?

I have a datatable with 4 columns A, B, C and D such that a particular combination of values for column A, B and C is unique in the datatable.

**Objective:** To find the value of column D, for a given combination of values for column A, B and C.

I guess looping over the set of data rows should do it. Is there a way to use Datatable.Select() to accomplish this? To be more specific - can I have multiple conditions in the select filter i.e. a logical AND operator connecting conditions for each of the columns A, B and C.


Datatable select with multiple conditions

I want to return all records that were added to the database within the last 30 days.  I need to convert the date to mm/dd/yy because of display purposes.  

    create_date between DATE_FORMAT(curdate(),&#39;%m/%d/%Y&#39;) AND (DATE_FORMAT(curdate() - interval 30 day,&#39;%m/%d/%Y&#39;)) 

My statement fails to limit the records to the last 30 days - it selects all the records.

Can anyone point me in the right direction?  It feels like I am close.

Thanks and have a great week.

MySQL Query - Records between Today and Last 30 Days

I was wondering if anybody knows how to select using js the complete table, so that the user can right-click on the selection, copy it to the clipboard and then paste it on Excel. If you select the table manually, the process works perfectly. But sometimes, if the table height is a few times larger than the screen, selecting it dragging the mouse gets tedious. So, I want to give the users the possibility to click on a &quot;select the whole table&quot; button and everything gets ready to be copied. 

Any ideas?


Select a complete table with Javascript (to be copied to clipboard)

How do I get a long text string (like a querystring) to display a maximum of 10 characters, using JQuery?

Sorry guys I&#39;m a novice at JavaScript &amp; JQuery :S  
Any help would be greatly appreciated.

Display only 10 characters of a long string?

For example, I get a string:

    str = &quot;please answer my question&quot;

I want to write it to a file.

But I need to know the size of the string before writing the string to the file. What function can I use to calculate the size of the string?

How to get the size of a string in Python?

I am doing a real estate feed for a portal and it is telling me the max length of a string should be 20,000 bytes (20kb), but I have never run across this before.

How can I measure `byte` size of a `varchar string`. So I can then do a while loop to trim it down.

Measure string size in Bytes in php

I want to find the longest `VARCHAR` in a specific column of a SQL Server table.

Here&#39;s an example:

    ID = INT IDENTITY
    DESC = VARCHAR(5000)

    ID | Desc
    ---|-----
    1  | a
    2  | aaa
    3  | aa

What&#39;s the SQL to return 3? Since the longest value is 3 characters?

Retrieve the maximum length of a VARCHAR column in SQL Server

How to find the length of a string (i.e., number of characters in a string) without splitting it in R? I know how to find the length of a list but not of a string.

And what about Unicode strings? How do I find the length (in bytes) and the number of characters (runes, symbols) in a Unicode string?

*Related Question:*

* https://stackoverflow.com/questions/42481827/how-to-find-the-real-number-of-characters-in-a-unicode-string-in-r

Content Type	Original Author	Original Content on Stackoverflow
Question	Gal	View Question on Stackoverflow
Solution 1 - Mysql	hsz	View Answer on Stackoverflow
Solution 2 - Mysql	Kaleb Brasee	View Answer on Stackoverflow
Solution 3 - Mysql	NeverHopeless	View Answer on Stackoverflow
Solution 4 - Mysql	Rito	View Answer on Stackoverflow
Solution 5 - Mysql	Ganesan J	View Answer on Stackoverflow
Solution 6 - Mysql	Jesús Sánchez	View Answer on Stackoverflow
Solution 7 - Mysql	Levi Maier	View Answer on Stackoverflow

MySQL - How to select data by string length

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Solution 5 - Mysql

Solution 6 - Mysql

Solution 7 - Mysql

Store boolean value in SQLite

How to convert SQLAlchemy row object to a Python dict?

Attributions