Search code examples
mysqlsql-likedatabase-partitioning

How to Partitioning a table using a LIKE criteria in Mysql

I've a large table to partition by value of a field of varchar(200) type. I have already read this question but because the size of the field I cannot use this solution.
My question is: Can I use a Like criteria as LIKE 'b%' or LIKE 'o%' and so on?
If not, How can I solve this?

Thanks in advance,
Antonio

Solution

  • You'd better specify the range as

    less than ('c')

    It is short and readable.