如何统计有特定字符的特定列的行数

SELECT COUNT(*) FROM my_table WHERE my_column LIKE '%a%';

import pandas as pd

# 假设你有一个 DataFrame df
df = pd.DataFrame({
    'my_column': ['apple', 'banana', 'cherry', 'date']
})

# 统计包含特定字符 'a' 的行数
count = df[df['my_column'].str.contains('a')].shape[0]
print(count)

const data = [
    { my_column: 'apple' },
    { my_column: 'banana' },
    { my_column: 'cherry' },
    { my_column: 'date' }
];

const count = data.filter(item => item.my_column.includes('a')).length;
console.log(count);

import java.sql.*;

public class Main {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            String sql = "SELECT COUNT(*) FROM my_table WHERE my_column LIKE ?";
            try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
                pstmt.setString(1, "%a%");
                try (ResultSet rs = pstmt.executeQuery()) {
                    if (rs.next()) {
                        int count = rs.getInt(1);
                        System.out.println(count);
                    }
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}