CODEWITHSUNDEEP
mysqlsql-likedatabase-partitioning
Antonio F.
Antonio F.

Reputation: 431

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

Upvotes: 0

Views: 499

Answers (2)

Antonio F.
Antonio F.

Reputation: 431

It seems that partitioning on varchar is allowed only if partitioning is by key (no duplicate values and no null values allowed).

Here a discussion

I tried to perform partitioning using a function that "converts" to integer values as ASCII(), but it doesn't compare in Mysql supported functions in partitioning expression.

List of supported functions

Upvotes: 0

zerkms
zerkms

Reputation: 255025

You'd better specify the range as

less than ('c')

It is short and readable.

Upvotes: 1

Related Questions