The mysql query field value is a number, and the mysql field value is a number.

The mysql query field value is a number, and the mysql field value is a number.
The SQL statement that I want to query where the field value is a number is as follows: select * from tj_item_result where tj_value REGEXP '^ [0-9]'

How does mysql query data with a field value not empty?

For example, to query the value of the title field not empty in Table:
Select * from a where title <> null;

Mysql multi-value field Query

If 80010 exists in the state, it will be wrong to use like,
You can use the following:
Select * from table where FIND_IN_SET ('20140901', state)> 0;
If 8001 * or * 8001 is not displayed, you can use like