Imagine this, you have a class and enum like:
|
1 2 3 4 5 6 7 8 |
class UserDto { public var username: String public var userStatus: UserStatusDto } enum UserStatusDto: String { case ok = "Ok" case error = "Error" } |
and you want to sort users by their status, but users with error first. How to do that? Continue reading
Well, first rule – you should not do this. But if there is good reason, consider using such query for searching in index-based arrays:
|
1 |
SELECT * FROM table WHERE your_field_here REGEXP '.*;s:[0-9]+:"your_value_here".*' |
In case you have assoc array serialized you can use:
|
1 |
SELECT * FROM table WHERE your_field_here REGEXP '.*"array_key_here";s:[0-9]+:"your_value_here".*' |
Of course it won’t be very fast but in small tables should be enough