What should I do if the SQL statement prompts that the expression type does not match?

Currently SQL does not support data type conversion queries. It is recommended to change jobid to int type. Generally, id fields are of int type. How do you use characters? I am sweating.

But if If this must be the case, you can use two queries and write a method. For the first query

select * from commsg where id is equal to the data id you want, and then force it into String, return;< /p>

Finally, just transfer this as a parameter to the second method you want to check